APPS.PQH_CRF_BUS dependencies on BEN_PL_F

Line 386: select null from BEN_PL_F a

382: l_api_updating boolean;
383: l_dummy varchar2(1);
384: --
385: cursor c1 is
386: select null from BEN_PL_F a
387: where a.pl_id = p_parent_rate_matrix_id;
388:
389: --
390: Begin

Line 405: -- BEN_PL_F table

401: <> nvl(pqh_crf_shd.g_old_rec.parent_rate_matrix_id,hr_api.g_number)
402: or not l_api_updating) then
403: --
404: -- check if PL_ID value exists in
405: -- BEN_PL_F table
406: --
407: open c1;
408: --
409: fetch c1 into l_dummy;

Line 415: -- raise error as FK does not relate to PK in BEN_PL_F

411: if c1%notfound then
412: --
413: close c1;
414: --
415: -- raise error as FK does not relate to PK in BEN_PL_F
416: -- table.
417: --
418: pqh_crf_shd.constraint_error('PQH_CRITERIA_RATE_FACTORS_FK4');
419: --