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_BUDGETED_SALARY_PKG dependencies on HR_PSF_SHD

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

48: or
49: (p_start_date between bud.budget_start_date and bud.budget_end_date) or
50: (p_end_date between bud.budget_start_date and bud.budget_end_date)
51: )
52: and ( hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = 'MONEY'
53: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = 'MONEY'
54: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = 'MONEY'
55: )
56: and bud.budget_id = bver.budget_id

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

49: (p_start_date between bud.budget_start_date and bud.budget_end_date) or
50: (p_end_date between bud.budget_start_date and bud.budget_end_date)
51: )
52: and ( hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = 'MONEY'
53: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = 'MONEY'
54: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = 'MONEY'
55: )
56: and bud.budget_id = bver.budget_id
57: and trunc(p_effective_date) between trunc(bver.date_from) and trunc(bver.date_to)

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

50: (p_end_date between bud.budget_start_date and bud.budget_end_date)
51: )
52: and ( hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = 'MONEY'
53: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = 'MONEY'
54: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = 'MONEY'
55: )
56: and bud.budget_id = bver.budget_id
57: and trunc(p_effective_date) between trunc(bver.date_from) and trunc(bver.date_to)
58: and nvl(p_organization_id, nvl(bdet.organization_id, -1)) =

Line 164: and ( hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = 'HOURS'

160: or
161: (p_start_date between bud.budget_start_date and bud.budget_end_date) or
162: (p_end_date between bud.budget_start_date and bud.budget_end_date)
163: )
164: and ( hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = 'HOURS'
165: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = 'HOURS'
166: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = 'HOURS'
167: )
168: and bud.budget_id = bver.budget_id

Line 165: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = 'HOURS'

161: (p_start_date between bud.budget_start_date and bud.budget_end_date) or
162: (p_end_date between bud.budget_start_date and bud.budget_end_date)
163: )
164: and ( hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = 'HOURS'
165: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = 'HOURS'
166: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = 'HOURS'
167: )
168: and bud.budget_id = bver.budget_id
169: and trunc(p_effective_date) between trunc(bver.date_from) and trunc(bver.date_to)

Line 166: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = 'HOURS'

162: (p_end_date between bud.budget_start_date and bud.budget_end_date)
163: )
164: and ( hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = 'HOURS'
165: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = 'HOURS'
166: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = 'HOURS'
167: )
168: and bud.budget_id = bver.budget_id
169: and trunc(p_effective_date) between trunc(bver.date_from) and trunc(bver.date_to)
170: and nvl(p_organization_id, nvl(bdet.organization_id, -1)) =