APPS.PAY_NL_PAYFILE_SEPA dependencies on PER_ADDRESSES

Line 147: FROM per_addresses pas

143: ,p_effective_date IN DATE) RETURN VARCHAR2 AS
144: --
145: CURSOR csr_get_per_address_style(p_payee_id NUMBER) IS -- to get the address style
146: SELECT substr(style,1,35) style
147: FROM per_addresses pas
148: WHERE pas.person_id = p_payee_id
149: AND pas.primary_flag = 'Y'
150: AND p_effective_date BETWEEN pas.date_from
151: AND nvl(pas.date_to,to_date('31/12/4712','DD/MM/YYYY'));

Line 163: FROM per_addresses pad

159: ,pad.address_line3 address_line3
160: ,pad.postal_code postcode
161: ,hr_general.decode_lookup('HR_NL_CITY',pad.town_or_city) city
162: ,pad.country country
163: FROM per_addresses pad
164: WHERE pad.person_id = p_payee_id
165: AND pad.primary_flag = 'Y'
166: AND p_effective_date BETWEEN pad.date_from
167: AND nvl(pad.date_to,to_date('31/12/4712','DD/MM/YYYY'));