DBA Data[Home] [Help]

APPS.PAY_ZA_PAYROLL_ACTION_PKG dependencies on PER_ADDRESSES

Line 338: from per_addresses pad,

334: pad.postal_code,
335: pad.region_3,
336: pad.town_or_city,
337: nvl(pad.region_2,'N') --Postal not same as residential address
338: from per_addresses pad,
339: hr_lookups l
340: where pad.person_id = p_person_id
341: and pad.primary_flag = 'Y'
342: and l.lookup_type(+) = 'ZA_PROVINCE'

Line 355: from per_addresses pad

351: , region_1 ee_street_name
352: , region_2 ee_suburb_district
353: , postal_code ee_postal_code
354: , town_or_city ee_town_city
355: from per_addresses pad
356: where person_id = p_person_id
357: and sysdate between nvl(pad.date_from, sysdate) and nvl(pad.date_to, sysdate)
358: and style = 'ZA_SARS'
359: and address_type = 'ZA_RES';