APPS.PQH_REALLOCATION_PKG dependencies on PQH_BUDGET_VERSIONS

Line 39: pqh_budget_versions bvr

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
42: and trunc(p_effective_date) between trunc(bud.budget_start_date) and trunc(bud.budget_end_date)
43: and bud.budget_id = bvr.budget_id

Line 90: pqh_budget_versions bvr

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
91: where trunc(p_effective_date) between trunc(bud.budget_start_date) and trunc(bud.budget_end_date)
92: and nvl(bud.position_control_flag,'X') = 'Y'
93: and bud.budgeted_entity_cd = p_budget_entity
94: and bud.business_group_id = p_business_group_id

Line 187: pqh_budget_versions bvr

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
188: where trunc(p_effective_date) between bud.budget_start_date and bud.budget_end_date
189: and bud.position_control_flag = 'Y'
190: and bud.budgeted_entity_cd = 'POSITION'
191: and rec_amt.transaction_type = l_txn_type