APPS.PAY_DK_SICKNESS_DP202 dependencies on PER_ADDRESSES

Line 168: per_addresses pa

164: pa.address_line1 address_line1
165: ,pa.address_line2 address_line2
166: ,pa.postal_code postal_code
167: FROM
168: per_addresses pa
169: WHERE
170: pa.person_id = p_person_id
171: AND pa.primary_flag = 'Y'
172: AND p_effective_date BETWEEN pa.date_from AND nvl(pa.date_to,TO_DATE('31/12/4712','dd/mm/yyyy'));