APPS.GHR_SF52_DO_UPDATE dependencies on GHR_PAY_PLANS

Line 4989: FROM ghr_pay_plans gpp

4985: l_wgi_new_name VARCHAR2(250);
4986:
4987: CURSOR c_wgi_pay_plan(c_pay_plan ghr_pa_requests.to_pay_plan%TYPE) IS
4988: SELECT 1
4989: FROM ghr_pay_plans gpp
4990: WHERE gpp.pay_plan = c_pay_plan
4991: AND gpp.wgi_enabled_flag = 'Y';
4992:
4993: CURSOR c_get_pay_plan(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS

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

4995: FROM ghr_pa_requests par
4996: WHERE par.pa_request_id = c_pa_request_id;
4997:
4998: -----GPPA Update46 Start.
4999: cursor cur_eq_ppl (c_pay_plan ghr_pay_plans.pay_plan%type)
5000: IS
5001: select EQUIVALENT_PAY_PLAN
5002: from ghr_pay_plans
5003: where pay_plan = c_pay_plan;

Line 5002: from ghr_pay_plans

4998: -----GPPA Update46 Start.
4999: cursor cur_eq_ppl (c_pay_plan ghr_pay_plans.pay_plan%type)
5000: IS
5001: select EQUIVALENT_PAY_PLAN
5002: from ghr_pay_plans
5003: where pay_plan = c_pay_plan;
5004:
5005: l_equ_pay_plan ghr_pay_plans.equivalent_pay_plaN%type;
5006: -----GPPA Update46 End.

Line 5005: l_equ_pay_plan ghr_pay_plans.equivalent_pay_plaN%type;

5001: select EQUIVALENT_PAY_PLAN
5002: from ghr_pay_plans
5003: where pay_plan = c_pay_plan;
5004:
5005: l_equ_pay_plan ghr_pay_plans.equivalent_pay_plaN%type;
5006: -----GPPA Update46 End.
5007:
5008: CURSOR c_check_ele(c_element_name pay_element_types_f.element_name%type,
5009: c_effective_date pay_element_entries_f.effective_start_date%type,

Line 7855: l_eq_pay_plan ghr_pay_plans.pay_plan%type;

7851:
7852: l_proc varchar2(72) := 'get_wgi_dates';
7853: l_initial_wgi_due_date date;
7854: l_payroll_id pay_payrolls_f.payroll_id%type;
7855: l_eq_pay_plan ghr_pay_plans.pay_plan%type;
7856: l_from_step ghr_pa_requests.to_step_or_rate%type;
7857: l_wgi_due_Date varchar2(60);
7858: l_wgi_pay_date date;
7859: l_wait_period ghr_pay_plan_waiting_periods.waiting_period%type;

Line 7860: l_pay_plan ghr_pay_plans.pay_plan%type;

7856: l_from_step ghr_pa_requests.to_step_or_rate%type;
7857: l_wgi_due_Date varchar2(60);
7858: l_wgi_pay_date date;
7859: l_wait_period ghr_pay_plan_waiting_periods.waiting_period%type;
7860: l_pay_plan ghr_pay_plans.pay_plan%type;
7861: l_step_or_rate ghr_pa_requests.to_step_or_rate%type;
7862: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
7863: l_maximum_step ghr_pa_requests.to_step_or_rate%type;
7864: l_grade_or_level ghr_pa_requests.to_grade_or_level%type;

Line 7882: from ghr_pay_plans gpp

7878: where asg.assignment_id = p_pa_request_rec.employee_assignment_id;
7879:
7880: Cursor c_equiv_pay_plan is
7881: select gpp.equivalent_pay_plan,gpp.maximum_Step
7882: from ghr_pay_plans gpp
7883: where gpp.pay_plan = l_pay_plan
7884: and gpp.wgi_enabled_flag = 'Y'; -- **also check for WGI enabled flag
7885: -- **calculate WGI only for eligible pay_plans and PRD
7886: Cursor c_next_step is -- ** WGI due date is null if the person has reached the max. step