DBA Data[Home] [Help]

APPS.PQH_CRE_BUS dependencies on PAY_INPUT_VALUES_F

Line 553: select null from PAY_INPUT_VALUES_F a

549: l_api_updating boolean;
550: l_dummy varchar2(1);
551: --
552: cursor c1 is
553: select null from PAY_INPUT_VALUES_F a
554: where a.input_value_id = p_input_value_id;
555:
556: --
557: Begin

Line 572: -- PAY_INPUT_VALUES_F table

568: <> nvl(pqh_cre_shd.g_old_rec.input_value_id,hr_api.g_number)
569: or not l_api_updating) then
570: --
571: -- check if input_value_id value exists in
572: -- PAY_INPUT_VALUES_F table
573: --
574: open c1;
575: --
576: fetch c1 into l_dummy;

Line 582: -- raise error as FK does not relate to PK in PAY_INPUT_VALUES_F

578: if c1%notfound then
579: --
580: close c1;
581: --
582: -- raise error as FK does not relate to PK in PAY_INPUT_VALUES_F
583: -- table.
584: --
585: pqh_cre_shd.constraint_error('PQH_CRITERIA_RATE_ELEMENTS_FK5');
586: --