APPS.PAY_GB_PAYROLL_ACTIONS_PKG dependencies on HR_LOOKUPS

Line 2985: hr_lookups l

2981: pad.postal_code,
2982: pad.region_3,
2983: pad.town_or_city
2984: from per_addresses pad,
2985: hr_lookups l
2986: where pad.person_id = p_person_id
2987: and pad.primary_flag = 'Y'
2988: and l.lookup_type(+) = 'GB_COUNTY'
2989: and l.lookup_code(+) = pad.region_1

Line 3028: hr_lookups l

3024: hrl.region_2,
3025: hrl.region_3,
3026: hrl.town_or_city
3027: from hr_locations hrl,
3028: hr_lookups l
3029: where hrl.location_id = p_location_id
3030: and l.lookup_type(+) = 'GB_COUNTY'
3031: and l.lookup_code(+) = hrl.region_1;
3032: --