APPS.GHR_UTILITY dependencies on HR_POSITIONS_F

Line 188: l_full_title hr_positions_f.name%type)

184: l_agency_code per_position_definitions.segment1%type,
185: l_po_id per_position_definitions.segment1%type,
186: l_grade per_position_definitions.segment1%type,
187: l_nfc_agency_code per_position_definitions.segment1%type,
188: l_full_title hr_positions_f.name%type)
189: RETURN VARCHAR2 IS
190: l_flex_num NUMBER;
191: l_flex_recs t_flex_recs;
192: TYPE t_pos_rec IS RECORD

Line 306: l_full_title hr_positions_f.name%type)

302: l_agency_code per_position_definitions.segment1%type,
303: l_po_id per_position_definitions.segment1%type,
304: l_grade per_position_definitions.segment1%type,
305: l_nfc_agency_code per_position_definitions.segment1%type,
306: l_full_title hr_positions_f.name%type)
307: RETURN VARCHAR2 IS
308: l_final VARCHAR2(2000);
309: l_delimiter VARCHAR2(10);
310: l_temp varchar2(2000);

Line 414: CURSOR c_check_child(c_position_id hr_positions_f.position_id%type) IS

410: and pos.position_id = c_position_id
411: and c_effective_date between pos.effective_start_date and
412: pos.effective_end_date;
413:
414: CURSOR c_check_child(c_position_id hr_positions_f.position_id%type) IS
415: SELECT 1 FROM hr_positions_f
416: WHERE information6 = to_char(c_position_id); -- Bug 4576746
417:
418: l_child_exists BOOLEAN;

Line 415: SELECT 1 FROM hr_positions_f

411: and c_effective_date between pos.effective_start_date and
412: pos.effective_end_date;
413:
414: CURSOR c_check_child(c_position_id hr_positions_f.position_id%type) IS
415: SELECT 1 FROM hr_positions_f
416: WHERE information6 = to_char(c_position_id); -- Bug 4576746
417:
418: l_child_exists BOOLEAN;
419: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;

Line 494: CURSOR c_check_child(c_position_id hr_positions_f.position_id%type) IS

490: P_POSITION_ID in NUMBER
491: ,P_EFFECTIVE_DATE in DATE
492: ) IS
493:
494: CURSOR c_check_child(c_position_id hr_positions_f.position_id%type) IS
495: SELECT 1 FROM hr_positions_f
496: WHERE information6 = to_char(c_position_id); -- Bug 4576746
497:
498: l_child_exists BOOLEAN;

Line 495: SELECT 1 FROM hr_positions_f

491: ,P_EFFECTIVE_DATE in DATE
492: ) IS
493:
494: CURSOR c_check_child(c_position_id hr_positions_f.position_id%type) IS
495: SELECT 1 FROM hr_positions_f
496: WHERE information6 = to_char(c_position_id); -- Bug 4576746
497:
498: l_child_exists BOOLEAN;
499: