APPS.PAY_GB_EOY_ARCHIVE dependencies on HR_LOOKUPS

Line 3497: hr_lookups l

3493: substr(l.meaning,1,27) county,
3494: substr(pad.postal_code,1,8),
3495: country
3496: FROM per_addresses pad,
3497: hr_lookups l
3498: WHERE pad.person_id = p_person_id
3499: AND pad.primary_flag = 'Y'
3500: AND l.lookup_type(+) = 'GB_COUNTY'
3501: AND l.lookup_code(+) = pad.region_1