APPS.PER_PEOPLE_V7_PKG dependencies on PER_STARTUP_PERSON_TYPES

Line 441: , per_startup_person_types pst

437: , pst.current_applicant_flag
438: , pst.current_emp_or_apl_flag
439: , pst.current_employee_flag
440: from per_person_types ppt
441: , per_startup_person_types pst
442: where ppt.business_group_id = p_business_group_id -- Bug fix 3645987
443: and pst.system_person_type = ppt.system_person_type
444: and ppt.active_flag = 'Y'
445: and ppt.default_flag = 'Y'

Line 745: , per_startup_person_types pst

741: , pst.current_applicant_flag
742: , pst.current_emp_or_apl_flag
743: , pst.current_employee_flag
744: from per_person_types ppt
745: , per_startup_person_types pst
746: where ppt.business_group_id = X_business_group_id --bug fix 3645987
747: and pst.system_person_type = ppt.system_person_type
748: and ppt.active_flag = 'Y'
749: and ppt.default_flag = 'Y'

Line 1852: , per_startup_person_types pst

1848: , pst.current_applicant_flag
1849: , pst.current_emp_or_apl_flag
1850: , to_date('31/12/4712','DD/MM/YYYY') effective_end_date
1851: from per_person_types ppt
1852: , per_startup_person_types pst
1853: where ppt.business_group_id =X_Business_group_id --Bug fix 3645987
1854: and ppt.system_person_type = pst.system_person_type
1855: and ppt.system_person_type = 'EMP'
1856: and ppt.default_flag = 'Y'

Line 2345: ,per_startup_person_types pst

2341: IS
2342: select 'Y'
2343: from per_people_f ppf
2344: ,per_person_types ppt
2345: ,per_startup_person_types pst
2346: where ppf.person_type_id = ppt.person_type_id
2347: and ppf.person_id = p_person_id
2348: and ppf.business_group_id +0 = ppt.business_group_id+0
2349: and ppf.business_group_id +0 = p_business_group_id