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_PSF_BUS

Line 32: PQH_PSF_BUS.GET_SYSTEM_SHARED_TYPE(budget_unit1_id), budget_unit1_aggregate,

28: bud.budget_start_date,
29: bud.budget_end_date,
30: bpr.reallocation_amt,
31: decode(p_system_budget_unit,
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,

Line 33: PQH_PSF_BUS.GET_SYSTEM_SHARED_TYPE(budget_unit2_id), budget_unit2_aggregate,

29: bud.budget_end_date,
30: bpr.reallocation_amt,
31: decode(p_system_budget_unit,
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,

Line 34: PQH_PSF_BUS.GET_SYSTEM_SHARED_TYPE(budget_unit3_id), budget_unit3_aggregate) budget_unit_aggregate

30: bpr.reallocation_amt,
31: decode(p_system_budget_unit,
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,

Line 59: and PQH_PSF_BUS.GET_SYSTEM_SHARED_TYPE(bpl.budget_unit_id) = p_system_budget_unit

55: -- and nvl(p_job_id, nvl(bpr.job_id, -1)) =
56: -- nvl(bpr.job_id, -1)
57: -- and nvl(p_grade_id, nvl(bpr.grade_id, -1)) =
58: -- nvl(bpr.grade_id, -1)
59: and PQH_PSF_BUS.GET_SYSTEM_SHARED_TYPE(bpl.budget_unit_id) = p_system_budget_unit
60: and (p_effective_date between bvr.date_from and bvr.date_to)
61: and bud.business_group_id = p_business_group_id
62: and ((p_start_date <= budget_start_date
63: and p_end_date >= budget_end_date

Line 82: PQH_PSF_BUS.GET_SYSTEM_SHARED_TYPE(budget_unit1_id), budget_unit1_aggregate,

78: bud.budget_start_date,
79: bud.budget_end_date,
80: decode(rec_amt.transaction_type,'DD',-1*rec_amt.reallocation_amt,'RD',rec_amt.reallocation_amt) reallocation_amt,
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,

Line 83: PQH_PSF_BUS.GET_SYSTEM_SHARED_TYPE(budget_unit2_id), budget_unit2_aggregate,

79: bud.budget_end_date,
80: decode(rec_amt.transaction_type,'DD',-1*rec_amt.reallocation_amt,'RD',rec_amt.reallocation_amt) reallocation_amt,
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,

Line 84: PQH_PSF_BUS.GET_SYSTEM_SHARED_TYPE(budget_unit3_id), budget_unit3_aggregate) budget_unit_aggregate

80: decode(rec_amt.transaction_type,'DD',-1*rec_amt.reallocation_amt,'RD',rec_amt.reallocation_amt) reallocation_amt,
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,

Line 109: and PQH_PSF_BUS.GET_SYSTEM_SHARED_TYPE(fld.budget_unit_id) = p_system_budget_unit

105: )
106: and bud.budget_id = bvr.budget_id
107: and trunc(p_effective_date) between trunc(bvr.date_from) and trunc(bvr.date_to)
108: and bvr.budget_version_id = fld.budget_version_id
109: and PQH_PSF_BUS.GET_SYSTEM_SHARED_TYPE(fld.budget_unit_id) = p_system_budget_unit
110: and fld.pool_id = trnx.parent_pool_id
111: and trnx.pool_id = trnx_dtl.pool_id
112: and trnx_dtl.reallocation_id = rec_amt.txn_detail_id
113: and nvl(p_position_id, nvl(rec_amt.entity_id, -1)) =

Line 205: and PQH_PSF_BUS.GET_SYSTEM_SHARED_TYPE(fld.budget_unit_id) = 'MONEY'

201: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = 'MONEY')
202: and bud.budget_id = bvr.budget_id
203: and trunc(p_effective_date) between bvr.date_from and bvr.date_to
204: and bvr.budget_version_id = fld.budget_version_id
205: and PQH_PSF_BUS.GET_SYSTEM_SHARED_TYPE(fld.budget_unit_id) = 'MONEY'
206: and fld.pool_id = trnx.parent_pool_id
207: and trnx.pool_id = trnx_dtl.pool_id
208: and trnx_dtl.reallocation_id = rec_amt.txn_detail_id
209: and rec_amt.entity_id = p_position_id;