APPS.GHR_NON_SF52_EXTRA_INFO dependencies on PER_POSITIONS

Line 469: p_position_id in per_positions.position_id%type ,

465: p_first_noa_id in number ,
466: p_second_noa_id in number ,
467: p_person_id in per_people_f.person_id%type ,
468: p_assignment_id in per_assignments_f.assignment_id%type ,
469: p_position_id in per_positions.position_id%type ,
470: p_effective_date in ghr_pa_requests.effective_date%type ,
471: p_refresh_flag in varchar2 default 'Y'
472: )
473: is

Line 633: p_position_id in per_positions.position_id%type,

629: (p_pa_request_id in number,
630: p_noa_id in number,
631: p_person_id in per_people_f.person_id%type,
632: p_assignment_id in per_assignments_f.assignment_id%type,
633: p_position_id in per_positions.position_id%type,
634: p_effective_date in ghr_pa_requests.effective_date%type,
635: p_refresh_flag in varchar2 default 'Y'
636: )
637: is

Line 659: l_position_id per_positions.position_id%type;

655: l_person_id per_people_f.person_id%type;
656: l_assignment_id per_assignments_f.assignment_id%type;
657: l_ret_review_date varchar2(30);
658: l_eff_date date;
659: l_position_id per_positions.position_id%type;
660: l_per_refresh_flag varchar2(1);
661: l_asg_refresh_flag varchar2(1);
662: l_pos_refresh_flag varchar2(1);
663: -- Bug#4089400

Line 2223: FROM per_positions

2219:
2220: Procedure chg_data_element is
2221: cursor c_bg is
2222: SELECT business_group_id
2223: FROM per_positions
2224: WHERE position_id = l_position_id;
2225: l_agency_code ghr_pa_requests.agency_code%type;
2226: l_bg_id per_positions.business_group_id%type;
2227: Begin

Line 2226: l_bg_id per_positions.business_group_id%type;

2222: SELECT business_group_id
2223: FROM per_positions
2224: WHERE position_id = l_position_id;
2225: l_agency_code ghr_pa_requests.agency_code%type;
2226: l_bg_id per_positions.business_group_id%type;
2227: Begin
2228: If l_position_id is not null then
2229: l_refresh_flag := l_pos_refresh_flag;
2230: ghr_history_fetch.fetch_positionei

Line 2399: FROM per_positions

2395: --
2396: Procedure gov_awards is
2397: cursor c_bg1 is
2398: SELECT business_group_id
2399: FROM per_positions
2400: WHERE position_id = p_position_id;
2401: cursor c_noa_code is
2402: SELECT 'X'
2403: FROM ghr_nature_of_actions

Line 2408: l_bg_id per_positions.business_group_id%type;

2404: WHERE nature_of_action_id = p_noa_id
2405: and code in ('825','840','841','842','843','844','845','846',
2406: '847','848','849','878','879' ); -- Bug 3266198 Added 848 and 849 to the NOA codes.
2407: l_agency_code ghr_pa_requests.agency_code%type;
2408: l_bg_id per_positions.business_group_id%type;
2409:
2410: --
2411: begin
2412: --