pears.NetCandidateRegDetails

CREATE PROCEDURE "pears"."NetCandidateRegDetails"( IN "pWebUserID" CHAR(20),IN "pPersonID" CHAR(20) ) 
RESULT( "PersonID" CHAR(20),"DivisionID" CHAR(20),"DivisionName" CHAR(30),"DepartmentID" CHAR(2),"DepartmentName" CHAR(30),"DepartmentTemp" SMALLINT,"DepartmentPerm" SMALLINT ) 
// IQXWeb
BEGIN
  SELECT top 1
    "p"."PersonID",
    "p"."DivisionID",
    "d"."Name" AS "DivisionName",
    "s"."DepartmentID",
    "dep"."Name" AS "DepartmentName",
    "s"."temp" AS "DepartmentTemp",
    "s"."permanent" AS "DepartmentPerm"
    FROM "person" AS "p" KEY LEFT OUTER JOIN "division" AS "d"
      ,"person" AS "p" KEY LEFT OUTER JOIN("search" AS "s" KEY JOIN "department" AS "dep")
    WHERE "p"."PersonID" = "NetCandidateValidPersonID"("pWebUserID","pPersonID")
    ORDER BY 1 ASC,4 ASC
END
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetCandidateRegDetails" IS 
{CREATE PROCEDURE pears."NetCandidateRegDetails"( IN pWebUserID CHAR(20), IN pPersonID CHAR(20) ) 
RESULT( PersonID CHAR(20), DivisionID CHAR(20), DivisionName CHAR(30), DepartmentID CHAR(2), DepartmentName CHAR(30), DepartmentTemp SMALLINT, DepartmentPerm SMALLINT ) 
// IQXWeb
BEGIN
  SELECT top 1
    p.PersonID, 
    p.DivisionID,
    d.Name AS DivisionName,
    s.DepartmentID,
    dep.Name AS DepartmentName,
    s.temp AS DepartmentTemp,
    s.permanent AS DepartmentPerm
  FROM 
    person p KEY LEFT OUTER JOIN division d,
    person p KEY LEFT OUTER JOIN (SEARCH s KEY JOIN department dep)
  WHERE
    p.PersonID=NetCandidateValidPersonID(pWebUserID,pPersonID)
  ORDER BY 1,4;
END
}