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 3861: (p_pa_request_id in ghr_pa_requests.pa_request_id%type,

3857: -- |--------------------------< call_work_flow>----------------|
3858: -- --------------------------------------------------------------------------
3859:
3860: Procedure call_workflow
3861: (p_pa_request_id in ghr_pa_requests.pa_request_id%type,
3862: p_action_taken in ghr_pa_routing_history.action_taken%type,
3863: p_old_action_taken in ghr_pa_routing_history.action_taken%type default null,
3864: p_error in varchar2 default null
3865: )

Line 3875: l_object_version_number ghr_pa_requests.object_version_number%type;

3871: l_cnt number;
3872: l_act_cnt number;
3873: l_groupbox_id number;
3874: l_user_name ghr_pa_routing_history.user_name%type;
3875: l_object_version_number ghr_pa_requests.object_version_number%type;
3876:
3877: Cursor c_par is
3878: select par.object_version_number
3879: from ghr_pa_requests par

Line 3879: from ghr_pa_requests par

3875: l_object_version_number ghr_pa_requests.object_version_number%type;
3876:
3877: Cursor c_par is
3878: select par.object_version_number
3879: from ghr_pa_requests par
3880: where par.pa_request_id = p_pa_request_id;
3881:
3882: Cursor c_routing_count is
3883: select count(*) cnt