APPS.PAY_NL_NSI_PROCESS dependencies on PER_ADDRESSES

Line 803: FROM per_addresses ee_addr

799: ,ee_addr.region_1 street_name
800: ,pay_nl_general.get_postal_code(ee_addr.postal_code) postal_code
801: ,hr_general.decode_lookup('HR_NL_CITY', ee_addr.town_or_city) city
802: ,ee_addr.country country
803: FROM per_addresses ee_addr
804: WHERE ee_addr.person_id = lp_person_id
805: AND lp_effective_date between date_from and NVL(date_to,hr_general.end_of_time)
806: AND ((ee_addr.primary_flag ='Y' AND lp_address_type IS NULL)
807: OR (lp_address_type IS NOT NULL AND ee_addr.address_type = lp_address_type));