APPS.PAY_NL_ATS_REPORT dependencies on PER_ADDRESSES

Line 170: from per_addresses pad

166: pad.postal_code postcode,
167: pad.town_or_city city,
168: pay_nl_general.get_country_name(pad.country) country,
169: pad.style add_style
170: from per_addresses pad
171: where pad.person_id = p_person_id
172: and p_effective_date between pad.date_from and nvl(pad.date_to,hr_general.end_of_time)
173: and pad.primary_flag = 'Y';
174:

Line 1798: from per_addresses pad

1794: pad.postal_code postcode,
1795: pad.town_or_city city,
1796: pay_nl_general.get_country_name(pad.country) country,
1797: pad.style add_style
1798: from per_addresses pad
1799: where pad.person_id = p_person_id
1800: and p_effective_date between pad.date_from and nvl(pad.date_to,hr_general.end_of_time)
1801: and pad.primary_flag = 'Y';
1802:

Line 3377: FROM per_addresses pad

3373:
3374: BEGIN
3375:
3376: SELECT pad.style INTO l_address_style
3377: FROM per_addresses pad
3378: WHERE pad.person_id = p_person_id
3379: AND pad.primary_flag = 'Y'
3380: AND p_effective_date between pad.date_from and nvl(pad.date_to,hr_general.end_of_time);
3381:

Line 3412: FROM per_addresses pad

3408:
3409: BEGIN
3410:
3411: SELECT pad.postal_code INTO l_post_code
3412: FROM per_addresses pad
3413: WHERE pad.person_id = p_person_id
3414: AND pad.primary_flag = 'Y'
3415: AND p_effective_date between pad.date_from and nvl(pad.date_to,hr_general.end_of_time);
3416: