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 1267: ,hr_all_organization_units org

1263: FROM per_all_people_f per
1264: ,per_all_assignments_f ass
1265: ,per_business_groups_perf bg
1266: ,hr_locations_all loc
1267: ,hr_all_organization_units org
1268: ,per_addresses adr
1269: WHERE ass.person_id(+) = per.person_id
1270: AND NVL(ass.primary_flag(+),'Y') = 'Y'
1271: AND NVL(ass.assignment_type(+),'E') = 'E'

Line 1591: ,hr_all_organization_units_tl bg

1587: SUBSTR(per.national_identifier,-4,4) "NationalIdentifier",
1588: per.business_group_id "BusinessGroupId"
1589: from per_all_people_f per
1590: ,per_all_assignments_f ass
1591: ,hr_all_organization_units_tl bg
1592: ,hr_locations_all_tl loc
1593: ,hr_all_organization_units_tl org
1594: ,per_addresses adr
1595: where ass.person_id(+) = per.person_id

Line 1593: ,hr_all_organization_units_tl org

1589: from per_all_people_f per
1590: ,per_all_assignments_f ass
1591: ,hr_all_organization_units_tl bg
1592: ,hr_locations_all_tl loc
1593: ,hr_all_organization_units_tl org
1594: ,per_addresses adr
1595: where ass.person_id(+) = per.person_id
1596: and ass.primary_flag(+) = 'Y'
1597: and ass.assignment_type(+) = 'E'

Line 1695: ,hr_all_organization_units org

1691: FROM per_all_people_f per
1692: ,per_all_assignments_f ass
1693: ,per_business_groups_perf bg
1694: ,hr_locations_all loc
1695: ,hr_all_organization_units org
1696: ,per_addresses adr
1697: WHERE ass.person_id(+) = per.person_id
1698: AND NVL(ass.primary_flag(+),'Y') = 'Y'
1699: AND NVL(ass.assignment_type(+),'E') = 'E'