APPS.PQH_BPL_BUS dependencies on PQH_BUDGETS

Line 303: l_budgeted_entity_cd pqh_budgets.budgeted_entity_cd%type;

299: --
300: l_proc varchar2(72) := g_package||'chk_budget_version_id';
301: l_api_updating boolean;
302: l_dummy varchar2(1);
303: l_budgeted_entity_cd pqh_budgets.budgeted_entity_cd%type;
304: --
305: cursor c1 is
306: select a.budgeted_entity_cd
307: from pqh_budgets a

Line 307: from pqh_budgets a

303: l_budgeted_entity_cd pqh_budgets.budgeted_entity_cd%type;
304: --
305: cursor c1 is
306: select a.budgeted_entity_cd
307: from pqh_budgets a
308: where a.budget_id = (Select budget_id
309: From pqh_budget_versions bvr
310: where bvr.budget_version_id = p_budget_version_id);
311: --

Line 325: -- check if budget_version_id value exists in pqh_budgets table

321: and nvl(p_budget_version_id,hr_api.g_number)
322: <> nvl(pqh_bpl_shd.g_old_rec.budget_version_id,hr_api.g_number)
323: or not l_api_updating) then
324: --
325: -- check if budget_version_id value exists in pqh_budgets table
326: --
327: open c1;
328: --
329: fetch c1 into l_budgeted_entity_cd;

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

330: if c1%notfound then
331: --
332: close c1;
333: --
334: -- raise error as FK does not relate to PK in pqh_budgets
335: -- table.
336: --
337: pqh_bpl_shd.constraint_error('PQH_BUDGET_POOLS_FK1');
338: --

Line 426: from pqh_budgets bgt

422: -- Check if the budget unit id belongs to the budget.
423: --
424: Cursor c2 is
425: Select null
426: from pqh_budgets bgt
427: Where bgt.budget_id = (Select budget_id
428: From pqh_budget_versions bvr
429: Where bvr.budget_version_id = p_budget_version_id)
430: and (bgt.budget_unit1_id = p_budget_unit_id or