APPS.PAY_GB_PAYROLL_ACTIONS_PKG dependencies on HR_LOOKUPS

Line 2584: hr_lookups l

2580: pad.postal_code,
2581: pad.region_3,
2582: pad.town_or_city
2583: from per_addresses pad,
2584: hr_lookups l
2585: where pad.person_id = p_person_id
2586: and pad.primary_flag = 'Y'
2587: and l.lookup_type(+) = 'GB_COUNTY'
2588: and l.lookup_code(+) = pad.region_1

Line 2627: hr_lookups l

2623: hrl.region_2,
2624: hrl.region_3,
2625: hrl.town_or_city
2626: from hr_locations hrl,
2627: hr_lookups l
2628: where hrl.location_id = p_location_id
2629: and l.lookup_type(+) = 'GB_COUNTY'
2630: and l.lookup_code(+) = hrl.region_1;
2631: --