APPS.GHR_API dependencies on GHR_PA_REQUESTS

Line 2696: l_pa_request_id ghr_pa_requests.pa_request_id%type;

2692: l_effective_date date;
2693: l_assignment_id per_assignments_f.assignment_id%type;
2694: v_assignment_id per_assignments_f.assignment_id%type;
2695: l_session ghr_history_api.g_session_var_type;
2696: l_pa_request_id ghr_pa_requests.pa_request_id%type;
2697: l_retained_grade ghr_pay_calc.retained_grade_rec_type;
2698: l_update34_date date;
2699: -- FWFA Changes Bug#4444609
2700: l_pay_basis varchar2(30);

Line 2810: from ghr_pa_requests

2806: select job_id, business_group_id
2807: from ghr_assignments_h_v
2808: where pa_request_id =
2809: (select min(pa_request_id)
2810: from ghr_pa_requests
2811: connect by pa_request_id = prior altered_pa_request_id
2812: start with pa_request_id = p_altered_pa_request_id
2813: and nature_of_action_id = p_noa_id_corrected
2814: );

Line 2824: from ghr_pa_requests

2820: select job_id, business_group_id
2821: from ghr_assignments_h_v
2822: where pa_request_id =
2823: (select min(pa_request_id)
2824: from ghr_pa_requests
2825: connect by pa_request_id = prior altered_pa_request_id
2826: start with pa_request_id = p_altered_pa_request_id
2827: );
2828: --order by pa_history_id desc;

Line 2832: from ghr_pa_requests

2828: --order by pa_history_id desc;
2829:
2830: Cursor c_orig_par_id is
2831: select min(pa_request_id) pa_request_id
2832: from ghr_pa_requests
2833: connect by pa_request_id = prior altered_pa_request_id
2834: start with pa_request_id = p_altered_pa_request_id;
2835:
2836: Cursor c_orig_par_rec is

Line 2862: from ghr_pa_requests par

2858: par.from_pay_table_identifier,
2859: -- FWFA Changes
2860: par.from_step_or_rate,
2861: par.from_total_salary
2862: from ghr_pa_requests par
2863: where pa_request_id = l_pa_request_id;
2864: --
2865: --
2866: begin

Line 3854: (p_pa_request_id in ghr_pa_requests.pa_request_id%type,

3850: -- |--------------------------< call_work_flow>----------------|
3851: -- --------------------------------------------------------------------------
3852:
3853: Procedure call_workflow
3854: (p_pa_request_id in ghr_pa_requests.pa_request_id%type,
3855: p_action_taken in ghr_pa_routing_history.action_taken%type,
3856: p_old_action_taken in ghr_pa_routing_history.action_taken%type default null,
3857: p_error in varchar2 default null
3858: )

Line 3868: l_object_version_number ghr_pa_requests.object_version_number%type;

3864: l_cnt number;
3865: l_act_cnt number;
3866: l_groupbox_id number;
3867: l_user_name ghr_pa_routing_history.user_name%type;
3868: l_object_version_number ghr_pa_requests.object_version_number%type;
3869:
3870: Cursor c_par is
3871: select par.object_version_number
3872: from ghr_pa_requests par

Line 3872: from ghr_pa_requests par

3868: l_object_version_number ghr_pa_requests.object_version_number%type;
3869:
3870: Cursor c_par is
3871: select par.object_version_number
3872: from ghr_pa_requests par
3873: where par.pa_request_id = p_pa_request_id;
3874:
3875: Cursor c_routing_count is
3876: select count(*) cnt