DBA Data[Home] [Help]

APPS.PAY_GB_RTI_P60 dependencies on HR_LOOKUPS

Line 337: hr_lookups l

333: substr(l.meaning,1,27) county,
334: substr(pad.postal_code,1,8),
335: country
336: FROM per_addresses pad,
337: hr_lookups l
338: WHERE pad.person_id = p_person_id
339: AND pad.primary_flag = 'Y'
340: AND l.lookup_type(+) = 'GB_COUNTY'
341: AND l.lookup_code(+) = pad.region_1