DBA Data[Home] [Help]

APPS.PQH_BDT_BUS dependencies on PQH_BUDGET_VERSIONS

Line 263: from pqh_budget_versions a

259: l_dummy varchar2(1);
260: --
261: cursor c1 is
262: select null
263: from pqh_budget_versions a
264: where a.budget_version_id = p_budget_version_id;
265: --
266: Begin
267: --

Line 280: -- check if budget_version_id value exists in pqh_budget_versions table

276: <> nvl(pqh_bdt_shd.g_old_rec.budget_version_id,hr_api.g_number)
277: or not l_api_updating) and
278: p_budget_version_id is not null then
279: --
280: -- check if budget_version_id value exists in pqh_budget_versions table
281: --
282: open c1;
283: --
284: fetch c1 into l_dummy;

Line 289: -- raise error as FK does not relate to PK in pqh_budget_versions

285: if c1%notfound then
286: --
287: close c1;
288: --
289: -- raise error as FK does not relate to PK in pqh_budget_versions
290: -- table.
291: --
292: pqh_bdt_shd.constraint_error('PQH_BUDGET_DETAILS_FK3');
293: --