Operation Details
Description: To retrieve the gender details for a prospect person record.
Sterotype: ns
SQL 
select
p.gender
into
:gender
from
prospectPerson p
where
p.concernRoleID = :concernRoleID;