DBA Data[Home] [Help]

APPS.OTA_ELIG_PROFILE_UTIL dependencies on PER_BUSINESS_GROUPS

Line 18: ,per_business_groups pbg

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'))
22: AND trunc(sysdate) BETWEEN ppf.effective_start_date AND ppf.effective_end_date