APPS.GHR_NON_SF52_EXTRA_INFO dependencies on PER_POSITIONS

Line 516: p_position_id in per_positions.position_id%type ,

512: p_first_noa_id in number ,
513: p_second_noa_id in number ,
514: p_person_id in per_people_f.person_id%type ,
515: p_assignment_id in per_assignments_f.assignment_id%type ,
516: p_position_id in per_positions.position_id%type ,
517: p_effective_date in ghr_pa_requests.effective_date%type ,
518: p_refresh_flag in varchar2 default 'Y'
519: )
520: is

Line 692: p_position_id in per_positions.position_id%type,

688: (p_pa_request_id in number,
689: p_noa_id in number,
690: p_person_id in per_people_f.person_id%type,
691: p_assignment_id in per_assignments_f.assignment_id%type,
692: p_position_id in per_positions.position_id%type,
693: p_effective_date in ghr_pa_requests.effective_date%type,
694: p_refresh_flag in varchar2 default 'Y'
695: )
696: is

Line 718: l_position_id per_positions.position_id%type;

714: l_person_id per_people_f.person_id%type;
715: l_assignment_id per_assignments_f.assignment_id%type;
716: l_ret_review_date varchar2(30);
717: l_eff_date date;
718: l_position_id per_positions.position_id%type;
719: l_per_refresh_flag varchar2(1);
720: l_asg_refresh_flag varchar2(1);
721: l_pos_refresh_flag varchar2(1);
722: -- Bug#4089400

Line 2652: FROM per_positions

2648:
2649: Procedure chg_data_element is
2650: cursor c_bg is
2651: SELECT business_group_id
2652: FROM per_positions
2653: WHERE position_id = l_position_id;
2654: l_agency_code ghr_pa_requests.agency_code%type;
2655: l_bg_id per_positions.business_group_id%type;
2656: Begin

Line 2655: l_bg_id per_positions.business_group_id%type;

2651: SELECT business_group_id
2652: FROM per_positions
2653: WHERE position_id = l_position_id;
2654: l_agency_code ghr_pa_requests.agency_code%type;
2655: l_bg_id per_positions.business_group_id%type;
2656: Begin
2657: If l_position_id is not null then
2658: l_refresh_flag := l_pos_refresh_flag;
2659: ghr_history_fetch.fetch_positionei

Line 2934: FROM per_positions

2930: --
2931: Procedure gov_awards is
2932: cursor c_bg1 is
2933: SELECT business_group_id
2934: FROM per_positions
2935: WHERE position_id = p_position_id;
2936: cursor c_noa_code is
2937: SELECT 'X'
2938: FROM ghr_nature_of_actions

Line 2943: l_bg_id per_positions.business_group_id%type;

2939: WHERE nature_of_action_id = p_noa_id
2940: and code in ('825','840','841','842','843','844','845','846',
2941: '847','848','849','878','879' ); -- Bug 3266198 Added 848 and 849 to the NOA codes.
2942: l_agency_code ghr_pa_requests.agency_code%type;
2943: l_bg_id per_positions.business_group_id%type;
2944:
2945: --
2946: begin
2947: --