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.PER_VACANCIES_PKG dependencies on HR_PSF_SHD

Line 1571: hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = 'HEAD'

1567: and budgeted_entity_cd = 'POSITION'
1568: and business_group_id = l_business_group_id
1569: and p_effective_date between budget_start_date and budget_end_date
1570: and (
1571: hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = 'HEAD'
1572: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = 'HEAD'
1573: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = 'HEAD'
1574: );
1575:

Line 1572: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = 'HEAD'

1568: and business_group_id = l_business_group_id
1569: and p_effective_date between budget_start_date and budget_end_date
1570: and (
1571: hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = 'HEAD'
1572: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = 'HEAD'
1573: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = 'HEAD'
1574: );
1575:
1576: --get the system type based on budget_nuit_id

Line 1573: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = 'HEAD'

1569: and p_effective_date between budget_start_date and budget_end_date
1570: and (
1571: hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = 'HEAD'
1572: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = 'HEAD'
1573: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = 'HEAD'
1574: );
1575:
1576: --get the system type based on budget_nuit_id
1577: cursor c1(p_unit_id number) is