DBA Data[Home] [Help]

APPS.PQH_RER_BUS dependencies on PAY_ELEMENT_TYPES_F

Line 396: select null from PAY_ELEMENT_TYPES_F a

392: l_api_updating boolean;
393: l_dummy varchar2(1);
394:
395: cursor c1 is
396: select null from PAY_ELEMENT_TYPES_F a
397: where a.element_type_id = p_rel_element_type_id;
398:
399: --
400: Begin

Line 415: -- PAY_ELEMENT_TYPES_F table

411: <> nvl(pqh_rer_shd.g_old_rec.rel_element_type_id,hr_api.g_number)
412: or not l_api_updating) then
413: --
414: -- check if rel_element_type_id value exists in
415: -- PAY_ELEMENT_TYPES_F table
416: --
417: open c1;
418: --
419:

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

423: if c1%notfound then
424: --
425: close c1;
426: --
427: -- raise error as FK does not relate to PK in PAY_ELEMENT_TYPES_F
428: -- table.
429: --
430: pqh_rer_shd.constraint_error('PQH_RATE_ELEMENT_RELATIONS_FK4');
431: --