APPS.HR_GENERAL2 dependencies on PER_ADDRESSES

Line 33: per_addresses has no underscore.

29: assignments status usages
30: dcasemor 19-MAR-2002 115.13 Added chk_utf8_col_length.
31: dcasemor 22-MAR-2002 115.14 Added address_line1, 2 and 3 to
32: chk_utf8_col_length because
33: per_addresses has no underscore.
34: dcasemor 26-MAR-2002 115.15 Scaled down use of
35: chk_utf8_col_length because this
36: has been replaced by
37: hr_utf8_triggers.

Line 1268: ,per_addresses adr

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'
1272: AND p_session_date BETWEEN NVL(ass.effective_start_date(+),p_session_date) AND NVL(ass.effective_end_date(+),p_session_date)

Line 1594: ,per_addresses adr

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'
1598: and per.business_group_id = p_business_group_id

Line 1696: ,per_addresses adr

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'
1700: AND l_session_date BETWEEN NVL(ass.effective_start_date(+),l_session_date) AND NVL(ass.effective_end_date(+),l_session_date)