eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PEOPLE_V7_PKG dependencies on PER_PERSON_TYPES

Line 440: from per_person_types ppt

436: select ppt.person_type_id
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'

Line 744: from per_person_types ppt

740: select ppt.person_type_id
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'

Line 1851: from per_person_types ppt

1847: , pst.current_employee_flag
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'

Line 2328: ,per_person_types ppt

2324: cursor future_exists
2325: IS
2326: select 'Y'
2327: from per_people_f ppf
2328: ,per_person_types ppt
2329: ,per_startup_person_types pst
2330: where ppf.person_type_id = ppt.person_type_id
2331: and ppf.person_id = p_person_id
2332: and ppf.business_group_id +0 = ppt.business_group_id+0