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_DB_PER_ADDITIONAL dependencies on HR_ORGANIZATION_UNITS

Line 1012: FROM hr_organization_units

1008: SELECT organization_id
1009: , location_id
1010: INTO l_organization_id
1011: , l_location_id
1012: FROM hr_organization_units
1013: WHERE name = p_organization
1014: AND business_group_id + 0 = l_business_group_id
1015: AND l_effective_start_date BETWEEN date_from
1016: AND nvl(date_to,to_date('4712/12/31',

Line 1410: FROM hr_organization_units

1406: SELECT organization_id
1407: , nvl(location_id, l_location_id)
1408: INTO l_organization_id
1409: , l_location_id
1410: FROM hr_organization_units
1411: WHERE name = p_organization
1412: AND business_group_id + 0 = l_business_group_id
1413: AND l_effective_start_date BETWEEN date_from
1414: AND nvl(date_to,to_date('4712/12/31',

Line 1833: FROM hr_organization_units

1829: SELECT organization_id
1830: , nvl(location_id, l_location_id)
1831: INTO l_organization_id
1832: , l_location_id
1833: FROM hr_organization_units
1834: WHERE name = p_organization
1835: AND business_group_id + 0 = l_business_group_id
1836: AND l_effective_start_date BETWEEN date_from
1837: AND nvl(date_to,to_date('4712/12/31',

Line 1975: FROM hr_organization_units

1971: SELECT organization_id
1972: , location_id
1973: INTO l_organization_id
1974: , l_location_id
1975: FROM hr_organization_units
1976: WHERE name = p_organization
1977: AND business_group_id + 0 = l_business_group_id
1978: AND l_effective_start_date BETWEEN date_from
1979: AND nvl(date_to,to_date('4712/12/31',