DBA Data[Home] [Help]

APPS.PAY_YEAR_END_EXTRACT dependencies on HR_LOOKUPS

Line 1217: hr_lookups l

1213: pad.town_or_city,
1214: SUBSTR(l.meaning,1,27) county,
1215: SUBSTR(pad.postal_code,1,8)
1216: from per_addresses pad,
1217: hr_lookups l
1218: where pad.person_id = ye_asg.person_id
1219: and pad.primary_flag = 'Y'
1220: and l.lookup_type(+) = 'GB_COUNTY'
1221: and l.lookup_code(+) = pad.region_1