DBA Data[Home] [Help]

APPS.HR_WPM_UTIL dependencies on PER_PERSON_TYPE_USAGES_F

Line 1010: FROM per_person_types typ, per_person_type_usages_f ptu

1006: SELECT 'Y'
1007: FROM SYS.DUAL
1008: WHERE EXISTS (
1009: SELECT NULL
1010: FROM per_person_types typ, per_person_type_usages_f ptu
1011: WHERE typ.system_person_type IN ('EMP', 'CWK', 'EMP_APL', 'APL'
1012: ,decode (fnd_profile.value ('PER_SP_SHOW_TERMINATED')
1013: ,'Y'
1014: ,'EX_EMP')