APPS.OTA_ELIG_PROFILE_UTIL dependencies on PER_PERSON_TYPE_USAGES_F

Line 16: ,per_person_type_usages_f ptu

12: , paf.assignment_type
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

Line 35: FROM per_person_type_usages_f ptf,

31: AND paf.business_group_id = pbg.business_group_id
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)