APPS.PAY_AC_TAXABILITY_WRAPPER dependencies on HR_LOOKUPS

Line 611: FROM hr_lookups

607: -- Bug# 5652699
608: CURSOR c_tax_category_code(cp_lookup_type in varchar2,
609: cp_lookup_code in varchar2) IS
610: SELECT lookup_code
611: FROM hr_lookups
612: WHERE upper(lookup_type) = upper(ltrim(rtrim(cp_lookup_type)))
613: AND (
614: upper(lookup_code) = upper(ltrim(rtrim(cp_lookup_code)))
615: OR

Line 632: hr_utility.trace('SELECT lookup_code FROM hr_lookups WHERE upper(lookup_type) = upper(ltrim(rtrim(cp_lookup_type))) AND upper(meaning) = upper(ltrim(rtrim(cp_lookup_code)))');

628: upper(p_classification), ' ', '_'),'-', '_');
629:
630: hr_utility.trace('l_lookup_type : ' || l_lookup_type);
631:
632: hr_utility.trace('SELECT lookup_code FROM hr_lookups WHERE upper(lookup_type) = upper(ltrim(rtrim(cp_lookup_type))) AND upper(meaning) = upper(ltrim(rtrim(cp_lookup_code)))');
633:
634: OPEN c_tax_category_code(l_lookup_type,p_tax_category);
635: FETCH c_tax_category_code INTO l_lookup_code;
636: if c_tax_category_code%NOTFOUND then