APPS.GHR_NFC_POSITION_EXTRACTS dependencies on PER_POSITION_DEFINITIONS

Line 30: FROM hr_all_positions_f pos, per_position_definitions pdf

26: ,c_effective_date IN Date) IS
27: SELECT pdf.segment3 NFC_Agency_Code,
28: pdf.segment4 Personnel_Office_ID,
29: pdf.segment7 Grade
30: FROM hr_all_positions_f pos, per_position_definitions pdf
31: WHERE pos.position_definition_id = pdf.position_definition_id
32: AND pos.position_id = c_position_id
33: AND c_effective_date between pos.effective_start_date and pos.effective_end_date;
34:

Line 2391: l_agency_code per_position_definitions.segment3%TYPE;

2387: l_posi_extra_info per_position_extra_info%rowtype;
2388: l_pos_extra_info t_pos_extra_info;
2389: l_pos number;
2390: l_ei number;
2391: l_agency_code per_position_definitions.segment3%TYPE;
2392: l_poi per_position_definitions.segment4%TYPE;
2393: l_grade per_position_definitions.segment5%TYPE;
2394: l_proc_name constant varchar2(150) := g_proc_name ||'get_poei_values';
2395: BEGIN

Line 2392: l_poi per_position_definitions.segment4%TYPE;

2388: l_pos_extra_info t_pos_extra_info;
2389: l_pos number;
2390: l_ei number;
2391: l_agency_code per_position_definitions.segment3%TYPE;
2392: l_poi per_position_definitions.segment4%TYPE;
2393: l_grade per_position_definitions.segment5%TYPE;
2394: l_proc_name constant varchar2(150) := g_proc_name ||'get_poei_values';
2395: BEGIN
2396: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

Line 2393: l_grade per_position_definitions.segment5%TYPE;

2389: l_pos number;
2390: l_ei number;
2391: l_agency_code per_position_definitions.segment3%TYPE;
2392: l_poi per_position_definitions.segment4%TYPE;
2393: l_grade per_position_definitions.segment5%TYPE;
2394: l_proc_name constant varchar2(150) := g_proc_name ||'get_poei_values';
2395: BEGIN
2396: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
2397: ghr_history_fetch.fetch_positionei