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.GHR_US_NFC_EXTRACTS dependencies on PER_POSITION_DEFINITIONS

Line 855: FROM hr_all_positions_f pos, per_position_definitions pdf

851: IS
852: SELECT pdf.segment3 NFC_Agency_Code,
853: pdf.segment4 POI,
854: pdf.segment7 Grade
855: FROM hr_all_positions_f pos, per_position_definitions pdf
856: WHERE pos.position_definition_id = pdf.position_definition_id
857: AND pos.position_id = cp_position_id
858: AND cp_effective_date between pos.effective_start_date
859: AND pos.effective_end_date

Line 1438: FROM hr_all_positions_f pos, per_position_definitions pdf

1434: ,cp_effective_date IN Date) IS
1435: SELECT pdf.segment3 NFC_Agency_Code,
1436: pdf.segment4 Personnel_Office_ID,
1437: pdf.segment7 Grade
1438: FROM hr_all_positions_f pos, per_position_definitions pdf
1439: WHERE pos.position_definition_id = pdf.position_definition_id
1440: AND pos.position_id = cp_position_id
1441: AND cp_effective_date between pos.effective_start_date and pos.effective_end_date;
1442: