DBA Data[Home] [Help]

APPS.PQH_CRE_BUS dependencies on PAY_ELEMENT_TYPES_F

Line 469: select null from PAY_ELEMENT_TYPES_F a

465: l_api_updating boolean;
466: l_dummy varchar2(1);
467: --
468: cursor c1 is
469: select null from PAY_ELEMENT_TYPES_F a
470: where a.element_type_id = p_element_type_id;
471:
472: --
473: Begin

Line 488: -- PAY_ELEMENT_TYPES_F table

484: <> nvl(pqh_cre_shd.g_old_rec.element_type_id,hr_api.g_number)
485: or not l_api_updating) then
486: --
487: -- check if element_type_id value exists in
488: -- PAY_ELEMENT_TYPES_F table
489: --
490: open c1;
491: --
492: fetch c1 into l_dummy;

Line 498: -- raise error as FK does not relate to PK in PAY_ELEMENT_TYPES_F

494: if c1%notfound then
495: --
496: close c1;
497: --
498: -- raise error as FK does not relate to PK in PAY_ELEMENT_TYPES_F
499: -- table.
500: --
501: pqh_cre_shd.constraint_error('PQH_CRITERIA_RATE_ELEMENTS_FK4');
502: --