APPS.GHR_UTILITY dependencies on HR_POSITIONS_F

Line 178: l_full_title hr_positions_f.name%type)

174: l_agency_code per_position_definitions.segment1%type,
175: l_po_id per_position_definitions.segment1%type,
176: l_grade per_position_definitions.segment1%type,
177: l_nfc_agency_code per_position_definitions.segment1%type,
178: l_full_title hr_positions_f.name%type)
179: RETURN VARCHAR2 IS
180: l_flex_num NUMBER;
181: l_flex_recs t_flex_recs;
182: TYPE t_pos_rec IS RECORD

Line 296: l_full_title hr_positions_f.name%type)

292: l_agency_code per_position_definitions.segment1%type,
293: l_po_id per_position_definitions.segment1%type,
294: l_grade per_position_definitions.segment1%type,
295: l_nfc_agency_code per_position_definitions.segment1%type,
296: l_full_title hr_positions_f.name%type)
297: RETURN VARCHAR2 IS
298: l_final VARCHAR2(2000);
299: l_delimiter VARCHAR2(10);
300: l_temp varchar2(2000);

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

400: and pos.position_id = c_position_id
401: and c_effective_date between pos.effective_start_date and
402: pos.effective_end_date;
403:
404: CURSOR c_check_child(c_position_id hr_positions_f.position_id%type) IS
405: SELECT 1 FROM hr_positions_f
406: WHERE information6 = to_char(c_position_id); -- Bug 4576746
407:
408: l_child_exists BOOLEAN;

Line 405: SELECT 1 FROM hr_positions_f

401: and c_effective_date between pos.effective_start_date and
402: pos.effective_end_date;
403:
404: CURSOR c_check_child(c_position_id hr_positions_f.position_id%type) IS
405: SELECT 1 FROM hr_positions_f
406: WHERE information6 = to_char(c_position_id); -- Bug 4576746
407:
408: l_child_exists BOOLEAN;
409: l_pos_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;

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

480: P_POSITION_ID in NUMBER
481: ,P_EFFECTIVE_DATE in DATE
482: ) IS
483:
484: CURSOR c_check_child(c_position_id hr_positions_f.position_id%type) IS
485: SELECT 1 FROM hr_positions_f
486: WHERE information6 = to_char(c_position_id); -- Bug 4576746
487:
488: l_child_exists BOOLEAN;

Line 485: SELECT 1 FROM hr_positions_f

481: ,P_EFFECTIVE_DATE in DATE
482: ) IS
483:
484: CURSOR c_check_child(c_position_id hr_positions_f.position_id%type) IS
485: SELECT 1 FROM hr_positions_f
486: WHERE information6 = to_char(c_position_id); -- Bug 4576746
487:
488: l_child_exists BOOLEAN;
489: