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.HR_BPL_ALERT_TRNSLT dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 54: FROM hr_all_organization_units_tl org1

50: , cp_language VARCHAR2 )
51: IS
52: SELECT org1.name
53: ,org1.language
54: FROM hr_all_organization_units_tl org1
55: WHERE org1.organization_id = cp_organization_id
56: AND ((org1.language = cp_language) OR
57: ((NOT EXISTS (SELECT 'x'
58: FROM hr_all_organization_units_tl org2

Line 58: FROM hr_all_organization_units_tl org2

54: FROM hr_all_organization_units_tl org1
55: WHERE org1.organization_id = cp_organization_id
56: AND ((org1.language = cp_language) OR
57: ((NOT EXISTS (SELECT 'x'
58: FROM hr_all_organization_units_tl org2
59: WHERE org1.organization_id = org2.organization_id
60: AND org2.language = cp_language)) AND
61: (org1.language = org1.source_lang)));
62: --