APPS.OKS_ATTR_DEFAULTS_PVT dependencies on FND_LOOKUPS

Line 9: SELECT MEANING FROM FND_LOOKUPS

5: ---------------------------------------------------------------------------
6: --Fix for Bug# 3542273
7: FUNCTION FND_MEANING(P_LOOKUP_CODE IN VARCHAR2,P_LOOKUP_TYPE IN VARCHAR2) RETURN VARCHAR2 IS
8: CURSOR C_LOOKUP_CODE IS
9: SELECT MEANING FROM FND_LOOKUPS
10: WHERE LOOKUP_CODE = P_LOOKUP_CODE
11: AND LOOKUP_TYPE = P_LOOKUP_TYPE;
12:
13: V_FOUND BOOLEAN := FALSE;

Line 762: from zx_exemptions ex, fnd_lookups lk

758:
759: -- Ebtax --
760: CURSOR tax_exemption_number_csr(p_tax_exemption_id IN NUMBER) IS
761: Select ex.exempt_certificate_number CUSTOMER_EXCEPTION_NUMBER, nvl(lk.lookup_code,ex.exempt_reason_code) Description
762: from zx_exemptions ex, fnd_lookups lk
763: where ex.tax_exemption_id = p_tax_exemption_id
764: and lk.lookup_type(+) = 'ZX_EXEMPTION_REASON_CODE'
765: and lk.lookup_code(+) = ex.exempt_reason_code;
766: