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_GENERAL2 dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1321: ,hr_all_organization_units org

1317: FROM per_all_people_f per
1318: ,per_all_assignments_f ass
1319: ,per_business_groups_perf bg
1320: ,hr_locations_all loc
1321: ,hr_all_organization_units org
1322: ,per_addresses adr
1323: WHERE ass.person_id(+) = per.person_id
1324: AND NVL(ass.primary_flag(+),'Y') = 'Y'
1325: AND NVL(ass.assignment_type(+),'E') = 'E'

Line 1646: ,hr_all_organization_units_tl bg

1642: SUBSTR(per.national_identifier,-4,4) "NationalIdentifier",
1643: per.business_group_id "BusinessGroupId"
1644: from per_all_people_f per
1645: ,per_all_assignments_f ass
1646: ,hr_all_organization_units_tl bg
1647: ,hr_locations_all_tl loc
1648: ,hr_all_organization_units_tl org
1649: ,per_addresses adr
1650: where ass.person_id(+) = per.person_id

Line 1648: ,hr_all_organization_units_tl org

1644: from per_all_people_f per
1645: ,per_all_assignments_f ass
1646: ,hr_all_organization_units_tl bg
1647: ,hr_locations_all_tl loc
1648: ,hr_all_organization_units_tl org
1649: ,per_addresses adr
1650: where ass.person_id(+) = per.person_id
1651: and ass.primary_flag(+) = 'Y'
1652: and ass.assignment_type(+) = 'E'

Line 1750: ,hr_all_organization_units org

1746: FROM per_all_people_f per
1747: ,per_all_assignments_f ass
1748: ,per_business_groups_perf bg
1749: ,hr_locations_all loc
1750: ,hr_all_organization_units org
1751: ,per_addresses adr
1752: WHERE ass.person_id(+) = per.person_id
1753: AND NVL(ass.primary_flag(+),'Y') = 'Y'
1754: AND NVL(ass.assignment_type(+),'E') = 'E'