APPS.PAY_NL_ATS_REPORT dependencies on PER_ADDRESSES

Line 154: from per_addresses pad

150: pad.postal_code postcode,
151: pad.town_or_city city,
152: pay_nl_general.get_country_name(pad.country) country,
153: pad.style add_style
154: from per_addresses pad
155: where pad.person_id = p_person_id
156: and p_effective_date between pad.date_from and nvl(pad.date_to,hr_general.end_of_time)
157: and pad.primary_flag = 'Y';
158:

Line 1751: from per_addresses pad

1747: pad.postal_code postcode,
1748: pad.town_or_city city,
1749: pay_nl_general.get_country_name(pad.country) country,
1750: pad.style add_style
1751: from per_addresses pad
1752: where pad.person_id = p_person_id
1753: and p_effective_date between pad.date_from and nvl(pad.date_to,hr_general.end_of_time)
1754: and pad.primary_flag = 'Y';
1755:

Line 3315: FROM per_addresses pad

3311:
3312: BEGIN
3313:
3314: SELECT pad.style INTO l_address_style
3315: FROM per_addresses pad
3316: WHERE pad.person_id = p_person_id
3317: AND pad.primary_flag = 'Y'
3318: AND p_effective_date between pad.date_from and nvl(pad.date_to,hr_general.end_of_time);
3319:

Line 3350: FROM per_addresses pad

3346:
3347: BEGIN
3348:
3349: SELECT pad.postal_code INTO l_post_code
3350: FROM per_addresses pad
3351: WHERE pad.person_id = p_person_id
3352: AND pad.primary_flag = 'Y'
3353: AND p_effective_date between pad.date_from and nvl(pad.date_to,hr_general.end_of_time);
3354: