APPS.OTA_ELIG_PROFILE_UTIL dependencies on PER_PERSON_TYPES

Line 17: ,per_person_types pts

13: , paf.business_group_id
14: FROM per_people_f ppf
15: ,per_assignments_f paf
16: ,per_person_type_usages_f ptu
17: ,per_person_types pts
18: ,per_business_groups pbg
19: WHERE
20: ppf.person_id = paf.person_id
21: AND ((pts.system_person_type IN ('EMP','CWK') AND paf.primary_flag = 'Y') OR (paf.assignment_type = 'A' AND pts.system_person_type ='APL'))

Line 36: per_person_types ptp WHERE trunc(sysdate) BETWEEN trunc(ptf.effective_start_date) AND trunc(ptf.effective_end_date)

32: AND
33: ((pts.system_person_type = 'APL'
34: AND NOT EXISTS (SELECT person_id
35: FROM per_person_type_usages_f ptf,
36: per_person_types ptp WHERE trunc(sysdate) BETWEEN trunc(ptf.effective_start_date) AND trunc(ptf.effective_end_date)
37: AND ptf.person_type_id = ptp.person_type_id
38: AND ptp.system_person_type IN ('EMP', 'CWK')
39: AND ptf.person_id = ppf.PERSON_ID)
40: )