DBA Data[Home] [Help]

APPS.HR_GENERAL2 dependencies on PER_ALL_ASSIGNMENTS_F

Line 1264: ,per_all_assignments_f ass

1260: ,adr.postal_code postal_code
1261: ,SUBSTR(per.national_identifier,-4,4) national_identifier
1262: ,per.business_group_id bg_id
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

Line 1590: ,per_all_assignments_f ass

1586: adr.postal_code "PostalCode",
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

Line 1692: ,per_all_assignments_f ass

1688: ,adr.postal_code "PostalCode"
1689: ,SUBSTR(per.national_identifier,-4,4) "NationalIdentifier"
1690: ,per.business_group_id "BusinessGroupId"
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