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.OTA_TDB_BUS2 dependencies on HR_ALL_ORGANIZATION_UNITS

Line 374: from hr_all_organization_units

370:
371: --
372: cursor c_organization is
373: select 1
374: from hr_all_organization_units
375: where organization_id = p_organization_id
376: and business_group_id = p_business_group_id;
377:
378: --

Line 985: FROM hr_all_organization_units_tl org,

981: SELECT org.name,
982: org.organization_id,
983: loc.country,
984: loc.location_id
985: FROM hr_all_organization_units_tl org,
986: hr_all_organization_units org1,
987: hr_locations_all loc
988: WHERE org.organization_id = org1.organization_id
989: AND loc.location_id(+) = org1.location_id

Line 986: hr_all_organization_units org1,

982: org.organization_id,
983: loc.country,
984: loc.location_id
985: FROM hr_all_organization_units_tl org,
986: hr_all_organization_units org1,
987: hr_locations_all loc
988: WHERE org.organization_id = org1.organization_id
989: AND loc.location_id(+) = org1.location_id
990: AND org.language = USERENV('LANG')