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_V15_PKG dependencies on PER_STARTUP_PERSON_TYPES

Line 332: , per_startup_person_types pst

328: , pst.current_applicant_flag
329: , pst.current_emp_or_apl_flag
330: , pst.current_employee_flag
331: from per_person_types ppt
332: , per_startup_person_types pst
333: where ppt.business_group_id = X_business_group_id -- Perf Fix 3648655
334: and pst.system_person_type = ppt.system_person_type
335: and ppt.active_flag = 'Y'
336: and ppt.default_flag = 'Y'

Line 679: , per_startup_person_types pst

675: , pst.current_applicant_flag
676: , pst.current_emp_or_apl_flag
677: , to_date('31/12/4712','DD/MM/YYYY') effective_end_date
678: from per_person_types ppt
679: , per_startup_person_types pst
680: where ppt.business_group_id =X_Business_group_id -- Perf Fix 3648655
681: and ppt.system_person_type = pst.system_person_type
682: and ppt.system_person_type = 'EMP'
683: and ppt.default_flag = 'Y'

Line 924: ,per_startup_person_types pst

920: IS
921: select 'Y'
922: from per_people_f ppf
923: ,per_person_types ppt
924: ,per_startup_person_types pst
925: where ppf.person_type_id = ppt.person_type_id
926: and ppf.person_id = p_person_id
927: and ppf.business_group_id +0 = ppt.business_group_id+0
928: and ppf.business_group_id +0 = p_business_group_id