====== pears.NetCandidateP45sList ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Original SQL =====
<code sql>
create procedure "pears"."NetCandidateP45sList"( in "pWebUserID" char(20),in "pPersonID" char(20) ) 
result( "p45id" char(20),"leavingdate" date,"employernameandaddress" long varchar,"p45Path" char(255) ) 
begin
  // iqxWEB
  if exists(select * from "sysobjects" where "name" = 'SoftNetDummyCandidateP45sList') then
    select "p45id","leavingdate","employernameandaddress","p45Path" from "SoftNetDummyCandidateP45sList"("pWebUserID") order by "leavingdate" desc
  else if exists(select * from "sysobjects" where "name" = 'SoftNetCandidateP45sList') then
      select "p45id","leavingdate","employernameandaddress","p45Path" from "SoftNetCandidateP45sList"("pWebUserID") order by "leavingdate" desc
    else
      select null,null,null,null from "dummy"
    end if
  end if
end /* DOC

2020-08-04 JG created

*/
/* TEST

*/
go

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetCandidateP45sList" IS 
{create PROCEDURE pears."NetCandidateP45sList"( in pWebUserID char(20), in pPersonID char(20) )
RESULT(p45id char(20), leavingdate date, employernameandaddress long varchar, p45Path char(255))
BEGIN
  // iqxWEB
    if exists(select * from sysobjects where name='SoftNetDummyCandidateP45sList') then
        select p45id, leavingdate, employernameandaddress, p45Path from SoftNetDummyCandidateP45sList(pWebUserID) order by leavingdate desc
    else if exists(select * from sysobjects where name='SoftNetCandidateP45sList') then
        select p45id, leavingdate, employernameandaddress, p45Path from SoftNetCandidateP45sList(pWebUserID) order by leavingdate desc
    else
        select null, null, null, null from dummy 
    end if;
    end if;
END

/* DOC

2020-08-04 JG created

*/

/* TEST

*/
}
</code>