DBA Data[Home] [Help]

APPS.HR_GENERAL2 dependencies on HR_ALL_ORGANIZATION_UNITS_TL

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'