APPS.GHR_SF52_UPDATE dependencies on GHR_PAY_PLANS

Line 40: from ghr_pay_plans

36: and p_effective_date between date_from and nvl(date_to,p_effective_date);
37:
38: CURSOR C3 is
39: select 1
40: from ghr_pay_plans
41: where pay_plan = p_to_pay_plan
42: and equivalent_pay_plan = 'GS';
43:
44: CURSOR C4 is