APPS.GHR_SF52_DO_UPDATE dependencies on GHR_PAY_PLAN_WAITING_PERIODS

Line 7859: l_wait_period ghr_pay_plan_waiting_periods.waiting_period%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;
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;

Line 7888: from ghr_pay_plan_waiting_periods gpw

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
7887: select gpw.to_step -- l_from_step
7888: from ghr_pay_plan_waiting_periods gpw
7889: where gpw.from_Step = l_step_or_rate
7890: and gpw.pay_plan = l_eq_pay_plan; -- pay plan -????
7891:
7892: Cursor c_waiting_period is

Line 7894: from ghr_pay_plan_waiting_periods gpw

7890: and gpw.pay_plan = l_eq_pay_plan; -- pay plan -????
7891:
7892: Cursor c_waiting_period is
7893: select gpw.waiting_period -- l_wait_period
7894: from ghr_pay_plan_waiting_periods gpw
7895: where gpw.pay_plan = l_eq_pay_plan
7896: and gpw.from_step = l_from_step; -- p_pa_request_rec.to_step_or_rate
7897:
7898: