APPS.PQH_REALLOCATION_PKG dependencies on PQH_BUDGET_POOLS

Line 37: pqh_budget_pools bpl,

33: PQH_PSF_BUS.GET_SYSTEM_SHARED_TYPE(budget_unit2_id), budget_unit2_aggregate,
34: PQH_PSF_BUS.GET_SYSTEM_SHARED_TYPE(budget_unit3_id), budget_unit3_aggregate) budget_unit_aggregate
35: from
36: pqh_bdgt_pool_realloctions bpr,
37: pqh_budget_pools bpl,
38: pqh_budgets bud,
39: pqh_budget_versions bvr
40: where
41: bpl.pool_id = bpr.pool_id

Line 85: from pqh_budget_pools fld,

81: decode(p_system_budget_unit,
82: PQH_PSF_BUS.GET_SYSTEM_SHARED_TYPE(budget_unit1_id), budget_unit1_aggregate,
83: PQH_PSF_BUS.GET_SYSTEM_SHARED_TYPE(budget_unit2_id), budget_unit2_aggregate,
84: PQH_PSF_BUS.GET_SYSTEM_SHARED_TYPE(budget_unit3_id), budget_unit3_aggregate) budget_unit_aggregate
85: from pqh_budget_pools fld,
86: pqh_budget_pools trnx,
87: pqh_bdgt_pool_realloctions trnx_dtl,
88: pqh_bdgt_pool_realloctions rec_amt,
89: pqh_budgets bud,

Line 86: pqh_budget_pools trnx,

82: PQH_PSF_BUS.GET_SYSTEM_SHARED_TYPE(budget_unit1_id), budget_unit1_aggregate,
83: PQH_PSF_BUS.GET_SYSTEM_SHARED_TYPE(budget_unit2_id), budget_unit2_aggregate,
84: PQH_PSF_BUS.GET_SYSTEM_SHARED_TYPE(budget_unit3_id), budget_unit3_aggregate) budget_unit_aggregate
85: from pqh_budget_pools fld,
86: pqh_budget_pools trnx,
87: pqh_bdgt_pool_realloctions trnx_dtl,
88: pqh_bdgt_pool_realloctions rec_amt,
89: pqh_budgets bud,
90: pqh_budget_versions bvr

Line 182: from pqh_budget_pools fld,

178: bud.budget_start_date,
179: bud.budget_end_date,
180: rec_amt.reallocation_amt,
181: rec_amt.reserved_amt
182: from pqh_budget_pools fld,
183: pqh_budget_pools trnx,
184: pqh_bdgt_pool_realloctions trnx_dtl,
185: pqh_bdgt_pool_realloctions rec_amt,
186: pqh_budgets bud,

Line 183: pqh_budget_pools trnx,

179: bud.budget_end_date,
180: rec_amt.reallocation_amt,
181: rec_amt.reserved_amt
182: from pqh_budget_pools fld,
183: pqh_budget_pools trnx,
184: pqh_bdgt_pool_realloctions trnx_dtl,
185: pqh_bdgt_pool_realloctions rec_amt,
186: pqh_budgets bud,
187: pqh_budget_versions bvr