DBA Data[Home] [Help]

APPS.PQH_BCE_BUS dependencies on PQH_BUDGETS

Line 187: from pqh_budgets a

183: l_dummy varchar2(1);
184: --
185: cursor c1 is
186: select null
187: from pqh_budgets a
188: where a.budget_id = p_budget_id;
189: --
190: Begin
191: --

Line 203: -- check if budget_id value exists in pqh_budgets table

199: and nvl(p_budget_id,hr_api.g_number)
200: <> nvl(pqh_bce_shd.g_old_rec.budget_id,hr_api.g_number)
201: or not l_api_updating) then
202: --
203: -- check if budget_id value exists in pqh_budgets table
204: --
205: open c1;
206: --
207: fetch c1 into l_dummy;

Line 212: -- raise error as FK does not relate to PK in pqh_budgets

208: if c1%notfound then
209: --
210: close c1;
211: --
212: -- raise error as FK does not relate to PK in pqh_budgets
213: -- table.
214: --
215: pqh_bce_shd.constraint_error('PQH_BDGT_CMMTMNT_ELMNTS_FK1');
216: --