APPS.PAY_ZA_PAYROLL_ACTION_PKG dependencies on HR_LOOKUPS

Line 339: hr_lookups l

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'
343: and l.lookup_code(+) = pad.region_1