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 HR_PSF_SHD

Line 69: hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = p_system_budget_unit

65: (p_start_date between budget_start_date and budget_end_date) or
66: (p_end_date between budget_start_date and budget_end_date)
67: )
68: and (
69: hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = p_system_budget_unit
70: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = p_system_budget_unit
71: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = p_system_budget_unit
72: );
73: ************************************************************************************kgowripe

Line 70: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = p_system_budget_unit

66: (p_end_date between budget_start_date and budget_end_date)
67: )
68: and (
69: hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = p_system_budget_unit
70: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = p_system_budget_unit
71: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = p_system_budget_unit
72: );
73: ************************************************************************************kgowripe
74: */

Line 71: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = p_system_budget_unit

67: )
68: and (
69: hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = p_system_budget_unit
70: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = p_system_budget_unit
71: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = p_system_budget_unit
72: );
73: ************************************************************************************kgowripe
74: */
75: cursor c_reallocation is

Line 102: hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = p_system_budget_unit

98: (p_start_date between budget_start_date and budget_end_date) or
99: (p_end_date between budget_start_date and budget_end_date)
100: )
101: and (
102: hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = p_system_budget_unit
103: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = p_system_budget_unit
104: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = p_system_budget_unit
105: )
106: and bud.budget_id = bvr.budget_id

Line 103: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = p_system_budget_unit

99: (p_end_date between budget_start_date and budget_end_date)
100: )
101: and (
102: hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = p_system_budget_unit
103: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = p_system_budget_unit
104: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_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)

Line 104: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = p_system_budget_unit

100: )
101: and (
102: hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = p_system_budget_unit
103: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = p_system_budget_unit
104: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_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

Line 199: and ( hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = 'MONEY'

195: ) or
196: (p_start_date between budget_start_date and budget_end_date) or
197: (p_end_date between budget_start_date and budget_end_date)
198: )
199: and ( hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = 'MONEY'
200: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_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

Line 200: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = 'MONEY'

196: (p_start_date between budget_start_date and budget_end_date) or
197: (p_end_date between budget_start_date and budget_end_date)
198: )
199: and ( hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = 'MONEY'
200: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_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

Line 201: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = 'MONEY')

197: (p_end_date between budget_start_date and budget_end_date)
198: )
199: and ( hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = 'MONEY'
200: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_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'