DBA Data[Home] [Help]

APPS.PAY_ZA_PAYROLL_ACTION_PKG dependencies on HR_LOOKUPS

Line 338: hr_lookups l

334: pad.postal_code,
335: pad.region_3,
336: pad.town_or_city
337: from per_addresses pad,
338: hr_lookups l
339: where pad.person_id = p_person_id
340: and pad.primary_flag = 'Y'
341: and l.lookup_type(+) = 'ZA_PROVINCE'
342: and l.lookup_code(+) = pad.region_1