APPS.GHR_US_NFC_EXTRACTS dependencies on PER_ADDRESSES
Line 1131: FROM per_addresses pa
1127: ,cp_effective_date DATE
1128: )
1129: IS
1130: SELECT * 1131: FROM per_addresses pa 1132: WHERE pa.person_id = cp_person_id
1133: AND pa.business_group_id=cp_business_group_id
1134: AND cp_effective_date BETWEEN pa.date_from
1135: AND NVL(pa.date_to,TO_DATE('12/31/4712','MM/DD/YYYY'))