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_ORGANIZATION_UNITS

Line 503: FROM HR_ORGANIZATION_UNITS HOU

499: P_organization_id NUMBER) IS
500:
501: CURSOR c_org_chk IS
502: SELECT 1
503: FROM HR_ORGANIZATION_UNITS HOU
504: WHERE HOU.ORGANIZATION_ID = P_organization_id
505: AND HOU.business_group_id + 0 = P_Business_group_id
506: AND P_vac_date_from < HOU.DATE_FROM;
507:

Line 541: FROM HR_ORGANIZATION_UNITS HOU

537: P_organization_id NUMBER) IS
538:
539: CURSOR c_org_chk IS
540: SELECT date_to
541: FROM HR_ORGANIZATION_UNITS HOU
542: WHERE HOU.ORGANIZATION_ID = P_organization_id
543: AND HOU.business_group_id + 0 = P_Business_group_id
544: AND P_vac_date_to > nvl(HOU.date_to, hr_api.g_eot);
545: