19: CURSOR csr_person_type IS
20: SELECT 'Y' FROM DUAL
21: WHERE EXISTS(SELECT ppt.system_person_type
22: FROM per_person_types ppt
23: ,per_person_type_usages_f ptu
24: ,fnd_sessions ses
25: WHERE ptu.person_id = p_person_id
26: AND ppt.person_type_id = ptu.person_type_id
27: AND ses.session_id=userenv('sessionid')