APPS.PAY_GB_EOY_ARCHIVE dependencies on HR_LOOKUPS

Line 3368: hr_lookups l

3364: substr(l.meaning,1,27) county,
3365: substr(pad.postal_code,1,8),
3366: country
3367: FROM per_addresses pad,
3368: hr_lookups l
3369: WHERE pad.person_id = p_person_id
3370: AND pad.primary_flag = 'Y'
3371: AND l.lookup_type(+) = 'GB_COUNTY'
3372: AND l.lookup_code(+) = pad.region_1