DBA Data[Home] [Help]

APPS.PER_ES_UPDATE_PERSON dependencies on PER_PERSON_TYPE_USAGES_F

Line 23: ,per_person_type_usages_f ptu

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')