DBA Data[Home] [Help]

APPS.PQH_BPL_BUS dependencies on PQH_BUDGET_VERSIONS

Line 309: From pqh_budget_versions bvr

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: --
312: Begin
313: --

Line 428: From pqh_budget_versions bvr

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
431: bgt.budget_unit2_id = p_budget_unit_id or
432: bgt.budget_unit3_id = p_budget_unit_id );