DBA Data[Home] [Help]

APPS.PQH_RFE_BUS dependencies on PQH_CRITERIA_RATE_FACTORS

Line 435: select null from pqh_criteria_rate_factors a

431: l_api_updating boolean;
432: l_dummy varchar2(1);
433: --
434: cursor c1 is
435: select null from pqh_criteria_rate_factors a
436: where a.criteria_rate_factor_id = p_criteria_rate_factor_id;
437:
438: --
439: Begin

Line 454: -- pqh_criteria_rate_factors table

450: <> nvl(pqh_rfe_shd.g_old_rec.criteria_rate_factor_id,hr_api.g_number)
451: or not l_api_updating) then
452: --
453: -- check if criteria_rate_factor_id value exists in
454: -- pqh_criteria_rate_factors table
455: --
456: open c1;
457: --
458:

Line 465: -- raise error as FK does not relate to PK in pqh_criteria_rate_factors

461: if c1%notfound then
462: --
463: close c1;
464: --
465: -- raise error as FK does not relate to PK in pqh_criteria_rate_factors
466: -- table.
467: --
468: pqh_rfe_shd.constraint_error('PQH_RATE_FACTOR_ON_ELMNTS_FK2');
469: --