DBA Data[Home] [Help]

APPS.PQH_BGT_BUS dependencies on PAY_CALENDARS

Line 516: from pay_calendars a

512: l_dummy varchar2(1);
513: --
514: cursor c1 is
515: select null
516: from pay_calendars a
517: where a.period_set_name = p_period_set_name;
518: --
519: Begin
520: --

Line 532: -- check if period_set_name value exists in pay_calendars table

528: and nvl(p_period_set_name,hr_api.g_varchar2)
529: <> nvl(pqh_bgt_shd.g_old_rec.period_set_name,hr_api.g_varchar2)
530: or not l_api_updating) then
531: --
532: -- check if period_set_name value exists in pay_calendars table
533: --
534: open c1;
535: --
536: fetch c1 into l_dummy;

Line 541: -- raise error as FK does not relate to PK in pay_calendars

537: if c1%notfound then
538: --
539: close c1;
540: --
541: -- raise error as FK does not relate to PK in pay_calendars
542: -- table.
543: --
544: pqh_bgt_shd.constraint_error('PQH_BUDGETS_FK1');
545: --