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_APPLICATIONS_PKG dependencies on PER_PERSON_TYPES

Line 901: FROM per_person_types PP

897: )
898: AND pap.effective_start_date = p_date_end + 1 -- If hired pap table has emp record with date_end+1
899: AND EXISTS
900: (SELECT 1
901: FROM per_person_types PP
902: WHERE pp.person_type_id = pap.person_type_id
903: AND PP.business_group_id + 0 = p_business_group_id
904: AND pp.active_flag ='Y'
905: AND pp.system_person_type IN ('EMP'));

Line 1863: PER_PERSON_TYPES PPT,

1859: --Bug2974671 ends here.
1860: ,PAPF.NPW_NUMBER -- Added for Fix for #3184546
1861:
1862: FROM per_all_people_f PAPF,
1863: PER_PERSON_TYPES PPT,
1864: per_person_types PPT2
1865: WHERE PAPF.person_id = P_person_id
1866: AND PAPF.effective_end_date = P_date_end
1867: AND PPT.business_group_id = P_business_group_id

Line 1864: per_person_types PPT2

1860: ,PAPF.NPW_NUMBER -- Added for Fix for #3184546
1861:
1862: FROM per_all_people_f PAPF,
1863: PER_PERSON_TYPES PPT,
1864: per_person_types PPT2
1865: WHERE PAPF.person_id = P_person_id
1866: AND PAPF.effective_end_date = P_date_end
1867: AND PPT.business_group_id = P_business_group_id
1868: and PAPF.business_group_id + 0 = P_Business_group_id

Line 2237: ,per_person_types ppt

2233: --changed for 2506446 from the old select
2234: cursor csr_ptu_row is
2235: select ptu.effective_start_date
2236: from per_person_type_usages_f ptu
2237: ,per_person_types ppt
2238: where ptu.person_id = p_person_id
2239: and ptu.effective_start_date > p_date_received
2240: and ptu.person_type_id = ppt.person_type_id
2241: and ppt.system_person_type = 'EX_APL'