APPS.HR_WPM_NTF_UTIL dependencies on PER_PERSON_TYPES

Line 77: FROM per_person_type_usages_f ptu, per_person_types ppt

73: OR ( plans.assignment_types_code = 'EC' AND sup.assignment_type IN ('E', 'C')
74: ) )
75: AND EXISTS (
76: SELECT 'x'
77: FROM per_person_type_usages_f ptu, per_person_types ppt
78: WHERE ptu.person_id = sup.person_id
79: AND TRUNC (SYSDATE) BETWEEN ptu.effective_start_date AND ptu.effective_end_date
80: AND ptu.person_type_id = ppt.person_type_id
81: AND ppt.system_person_type IN ('EMP', 'CWK', 'EMP_APL', 'CWK_APL'));