DBA Data[Home] [Help]

APPS.AP_1099_UTILITIES_PKG dependencies on PER_ADDRESSES

Line 1055: PER_ADDRESSES per_addr,

1051: per_addr.country
1052: end
1053: end COUNTRY
1054: FROM HR_LOCATIONS per_loc,
1055: PER_ADDRESSES per_addr,
1056: PER_ALL_ASSIGNMENTS_F per_assgn,
1057: PER_ADDRESSES per_addr_prov,
1058: (SELECT distinct papf1.person_id, papf1.national_identifier
1059: FROM PER_ALL_PEOPLE_F papf1

Line 1057: PER_ADDRESSES per_addr_prov,

1053: end COUNTRY
1054: FROM HR_LOCATIONS per_loc,
1055: PER_ADDRESSES per_addr,
1056: PER_ALL_ASSIGNMENTS_F per_assgn,
1057: PER_ADDRESSES per_addr_prov,
1058: (SELECT distinct papf1.person_id, papf1.national_identifier
1059: FROM PER_ALL_PEOPLE_F papf1
1060: WHERE NVL(papf1.effective_end_date,sysdate +9000) =
1061: (SELECT MAX(DECODE(papf2.effective_end_date,'',sysdate+9000,papf2.effective_end_date))