DBA Data[Home] [Help]

APPS.PER_ES_UPDATE_PERSON dependencies on DUAL

Line 20: SELECT 'Y' FROM DUAL

16: WHERE lookup_type='ES_IDENTIFIER_TYPE'
17: AND lookup_code=p_per_information2;
18:
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