DBA Data[Home] [Help]

APPS.PQH_REALLOCATION_PKG dependencies on PQH_BUDGETS

Line 38: pqh_budgets bud,

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

Line 89: pqh_budgets bud,

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
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

Line 186: pqh_budgets bud,

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
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'