APPS.GHR_SF52_DO_UPDATE dependencies on GHR_PAY_PLAN_WAITING_PERIODS

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

Line 8191: from ghr_pay_plan_waiting_periods gpw

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
8190: select gpw.to_step -- l_from_step
8191: from ghr_pay_plan_waiting_periods gpw
8192: where gpw.from_Step = l_step_or_rate
8193: and gpw.pay_plan = l_eq_pay_plan; -- pay plan -????
8194:
8195: Cursor c_waiting_period is

Line 8197: from ghr_pay_plan_waiting_periods gpw

8193: and gpw.pay_plan = l_eq_pay_plan; -- pay plan -????
8194:
8195: Cursor c_waiting_period is
8196: select gpw.waiting_period -- l_wait_period
8197: from ghr_pay_plan_waiting_periods gpw
8198: where gpw.pay_plan = l_eq_pay_plan
8199: and gpw.from_step = l_from_step; -- p_pa_request_rec.to_step_or_rate
8200:
8201: