DBA Data[Home] [Help]

APPS.PQH_WDT_BUS dependencies on PQH_BUDGET_DETAILS

Line 525: from pqh_budget_details a

521: l_dummy varchar2(1);
522: --
523: cursor c1 is
524: select null
525: from pqh_budget_details a
526: where a.budget_detail_id = p_budget_detail_id;
527: --
528: Begin
529: --

Line 542: -- check if budget_detail_id value exists in pqh_budget_details table

538: <> nvl(pqh_wdt_shd.g_old_rec.budget_detail_id,hr_api.g_number)
539: or not l_api_updating) and
540: p_budget_detail_id is not null then
541: --
542: -- check if budget_detail_id value exists in pqh_budget_details table
543: --
544: open c1;
545: --
546: fetch c1 into l_dummy;

Line 551: -- raise error as FK does not relate to PK in pqh_budget_details

547: if c1%notfound then
548: --
549: close c1;
550: --
551: -- raise error as FK does not relate to PK in pqh_budget_details
552: -- table.
553: --
554: pqh_wdt_shd.constraint_error('PQH_WORKSHEET_DETAILS_FK3');
555: --