DBA Data[Home] [Help]

APPS.GHR_MASS_CON_PROGRAM dependencies on GHR_PAY_PLANS

Line 393: g_equivalent_pay_plan ghr_pay_plans.equivalent_pay_plan%TYPE;

389: )
390: IS
391:
392: l_proc varchar2(72) := g_package || 'get_furlough_rtd_lac';
393: g_equivalent_pay_plan ghr_pay_plans.equivalent_pay_plan%TYPE;
394: cursor c_eql_pay_plan is
395: SELECT equivalent_pay_plan
396: INTO g_equivalent_pay_plan
397: FROM ghr_pay_plans

Line 397: FROM ghr_pay_plans

393: g_equivalent_pay_plan ghr_pay_plans.equivalent_pay_plan%TYPE;
394: cursor c_eql_pay_plan is
395: SELECT equivalent_pay_plan
396: INTO g_equivalent_pay_plan
397: FROM ghr_pay_plans
398: WHERE pay_plan = p_pay_plan;
399:
400: BEGIN
401: