APPS.PAY_IE_PAYFILE_SEPA dependencies on PER_ADDRESSES

Line 301: FROM per_addresses pad

297: ,pad.address_line3 address_line3
298: ,pad.country country
299: ,pad.postal_code postcode
300: ,pad.region_2 geo_code
301: FROM per_addresses pad
302: WHERE pad.person_id = p_payee_id
303: AND pad.primary_flag = 'Y'
304: AND p_effective_date BETWEEN pad.date_from
305: AND nvl(pad.date_to,to_date('31/12/4712','DD/MM/YYYY'));