APPS.GHR_SF52_DO_UPDATE dependencies on GHR_PAY_PLANS

Line 5248: FROM ghr_pay_plans gpp

5244: l_wgi_new_name VARCHAR2(250);
5245:
5246: CURSOR c_wgi_pay_plan(c_pay_plan ghr_pa_requests.to_pay_plan%TYPE) IS
5247: SELECT 1
5248: FROM ghr_pay_plans gpp
5249: WHERE gpp.pay_plan = c_pay_plan
5250: AND gpp.wgi_enabled_flag = 'Y';
5251:
5252: CURSOR c_get_pay_plan(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS

Line 5258: cursor cur_eq_ppl (c_pay_plan ghr_pay_plans.pay_plan%type)

5254: FROM ghr_pa_requests par
5255: WHERE par.pa_request_id = c_pa_request_id;
5256:
5257: -----GPPA Update46 Start.
5258: cursor cur_eq_ppl (c_pay_plan ghr_pay_plans.pay_plan%type)
5259: IS
5260: select EQUIVALENT_PAY_PLAN
5261: from ghr_pay_plans
5262: where pay_plan = c_pay_plan;

Line 5261: from ghr_pay_plans

5257: -----GPPA Update46 Start.
5258: cursor cur_eq_ppl (c_pay_plan ghr_pay_plans.pay_plan%type)
5259: IS
5260: select EQUIVALENT_PAY_PLAN
5261: from ghr_pay_plans
5262: where pay_plan = c_pay_plan;
5263:
5264: l_equ_pay_plan ghr_pay_plans.equivalent_pay_plaN%type;
5265: -----GPPA Update46 End.

Line 5264: l_equ_pay_plan ghr_pay_plans.equivalent_pay_plaN%type;

5260: select EQUIVALENT_PAY_PLAN
5261: from ghr_pay_plans
5262: where pay_plan = c_pay_plan;
5263:
5264: l_equ_pay_plan ghr_pay_plans.equivalent_pay_plaN%type;
5265: -----GPPA Update46 End.
5266:
5267: CURSOR c_check_ele(c_element_name pay_element_types_f.element_name%type,
5268: c_effective_date pay_element_entries_f.effective_start_date%type,

Line 8158: l_eq_pay_plan ghr_pay_plans.pay_plan%type;

8154:
8155: l_proc varchar2(72) := 'get_wgi_dates';
8156: l_initial_wgi_due_date date;
8157: l_payroll_id pay_payrolls_f.payroll_id%type;
8158: l_eq_pay_plan ghr_pay_plans.pay_plan%type;
8159: l_from_step ghr_pa_requests.to_step_or_rate%type;
8160: l_wgi_due_Date varchar2(60);
8161: l_wgi_pay_date date;
8162: l_wait_period ghr_pay_plan_waiting_periods.waiting_period%type;

Line 8163: l_pay_plan ghr_pay_plans.pay_plan%type;

8159: l_from_step ghr_pa_requests.to_step_or_rate%type;
8160: l_wgi_due_Date varchar2(60);
8161: l_wgi_pay_date date;
8162: l_wait_period ghr_pay_plan_waiting_periods.waiting_period%type;
8163: l_pay_plan ghr_pay_plans.pay_plan%type;
8164: l_step_or_rate ghr_pa_requests.to_step_or_rate%type;
8165: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
8166: l_maximum_step ghr_pa_requests.to_step_or_rate%type;
8167: l_grade_or_level ghr_pa_requests.to_grade_or_level%type;

Line 8185: from ghr_pay_plans gpp

8181: where asg.assignment_id = p_pa_request_rec.employee_assignment_id;
8182:
8183: Cursor c_equiv_pay_plan is
8184: select gpp.equivalent_pay_plan,gpp.maximum_Step
8185: from ghr_pay_plans gpp
8186: where gpp.pay_plan = l_pay_plan
8187: and gpp.wgi_enabled_flag = 'Y'; -- **also check for WGI enabled flag
8188: -- **calculate WGI only for eligible pay_plans and PRD
8189: Cursor c_next_step is -- ** WGI due date is null if the person has reached the max. step