APPS.AP_WEB_DB_AP_INT_PKG dependencies on HR_LOOKUPS

Line 245: FROM hr_lookups

241: AND (vdr.employee_id = p_employee_id OR (l_vendor_id is not null and l_vendor_id = vdr.vendor_id)) -- Bug 6978871(sodash)
242: AND c.currency_code(+) = site.payment_currency_code
243: AND upper(site.vendor_site_code) =
244: (SELECT upper(meaning)
245: FROM hr_lookups
246: WHERE lookup_code = l_expense_check_address_flag
247: AND lookup_type = 'HOME_OFFICE');
248: IF p_vend_pay_curr_code IS NULL THEN
249: l_get_from_vendor := 'Y';