APPS.GHR_US_NFC_EXTRACTS dependencies on HR_ALL_POSITIONS_F

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 1425: FROM hr_all_positions_f hap

1421: ,cp_business_group_id NUMBER
1422: )
1423: IS
1424: SELECT hap.information6 mrn
1425: FROM hr_all_positions_f hap
1426: WHERE hap.position_id =cp_position_id
1427: AND cp_effective_date BETWEEN hap.effective_start_date
1428: AND hap.effective_end_date
1429: AND hap.business_group_id =cp_business_group_id;

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:

Line 1506: l_position_id hr_all_positions_f.position_id%TYPE;

1502: l_auth_date DATE;
1503: l_get_default_values c_get_default_values%ROWTYPE;
1504: l_get_asg_extra_info c_get_asg_extra_info%ROWTYPE;
1505: l_mast_pos c_mast_pos%ROWTYPE;
1506: l_position_id hr_all_positions_f.position_id%TYPE;
1507: l_out_val pay_element_entry_values_f.screen_entry_value%type;
1508: l_pos_num VARCHAR2(20);
1509: l_get_ei_val ghr_pa_request_extra_info%ROWTYPE;
1510: l_temp_var NUMBER;