APPS.PAY_IE_PAY_ADVICE_REPORT dependencies on HR_LOOKUPS

Line 84: HR_LOOKUPS HR_COUNTY

80:
81: hr_utility.trace('Entering ' ||g_package || 'get_region1' );
82: select HR_COUNTY.meaning into l_REGION_1
83: from hr_locations_all,
84: HR_LOOKUPS HR_COUNTY
85: where location_code = p_location_code and
86: nvl(BUSINESS_GROUP_ID,p_business_group_id) =
87: p_business_group_id AND
88: HR_COUNTY.LOOKUP_TYPE(+) ='IE_COUNTY' AND