APPS.GHR_PDC_BUS dependencies on GHR_PAY_PLANS

Line 223: l_pay_plan ghr_pay_plans.pay_plan%TYPE;

219: IS
220:
221: l_proc varchar2(72) := g_package||'chk_pay_plan';
222: l_api_updating boolean;
223: l_pay_plan ghr_pay_plans.pay_plan%TYPE;
224:
225: CURSOR c_pay_plan
226: IS
227: SELECT pay_plan

Line 228: FROM ghr_pay_plans

224:
225: CURSOR c_pay_plan
226: IS
227: SELECT pay_plan
228: FROM ghr_pay_plans
229: WHERE pay_plan = p_pay_plan;
230:
231:
232: BEGIN

Line 267: -- Check if the pay plan is in GHR_PAY_PLANS

263: --
264: hr_utility.set_location(l_proc,20);
265: --
266: -- If pay plan is not null then
267: -- Check if the pay plan is in GHR_PAY_PLANS
268: -- This is an extra check apart from the foreign key on the table.
269: --
270:
271: IF p_pay_plan is NOT NULL THEN