DBA Data[Home] [Help]

APPS.HR_GENERAL2 dependencies on HR_ALL_ORGANIZATION_UNITS_TL

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'