eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_REALLOCATION_PKG dependencies on PQH_BDGT_POOL_REALLOCTIONS

Line 36: pqh_bdgt_pool_realloctions bpr,

32: PQH_PSF_BUS.GET_SYSTEM_SHARED_TYPE(budget_unit1_id), budget_unit1_aggregate,
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

Line 87: pqh_bdgt_pool_realloctions trnx_dtl,

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

Line 88: pqh_bdgt_pool_realloctions rec_amt,

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

Line 184: pqh_bdgt_pool_realloctions trnx_dtl,

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

Line 185: pqh_bdgt_pool_realloctions rec_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
188: where trunc(p_effective_date) between bud.budget_start_date and bud.budget_end_date
189: and bud.position_control_flag = 'Y'