====== pears.NetAgencyCandidateStatusChoices ======
<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"."NetAgencyCandidateStatusChoices"( in "pWebUserID" char(20) ) 
result( "Description" char(40),"ID" char(1) ) 
begin
  select "Name","SecondaryAgencyCandidateStatusID" from "SecondaryAgencyCandidateStatus" order by "SortOrder" asc,"Name" asc
end
go

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetAgencyCandidateStatusChoices" IS 
{create PROCEDURE pears."NetAgencyCandidateStatusChoices"( in "pWebUserID" char(20) )
RESULT(Description char(40), ID char(1) ) 
BEGIN
select Name, SecondaryAgencyCandidateStatusID from SecondaryAgencyCandidateStatus  order by SortOrder, Name
END
}
</code>