DBA Data[Home] [Help]

APPS.PO_AP_TAX_CODES_SV dependencies on FND_LOOKUPS

Line 21: FROM FND_LOOKUPS

17:
18:
19: Select 'Y' into l_temp from dual where exists
20: (SELECT MEANING, LOOKUP_CODE TAX_CLASSIFICATION_CODE
21: FROM FND_LOOKUPS
22: WHERE LOOKUP_TYPE = 'ZX_INPUT_CLASSIFICATIONS'
23: AND NVL(START_DATE_ACTIVE, SYSDATE) <= SYSDATE
24: AND NVL(END_DATE_ACTIVE, SYSDATE) >= SYSDATE
25: AND ENABLED_FLAG = 'Y'

Line 29: FROM FND_LOOKUPS

25: AND ENABLED_FLAG = 'Y'
26: AND LOOKUP_CODE = x_tax_name
27: UNION
28: SELECT MEANING, LOOKUP_CODE TAX_CLASSIFICATION_CODE
29: FROM FND_LOOKUPS
30: WHERE LOOKUP_TYPE = 'ZX_WEB_EXP_TAX_CLASSIFICATIONS'
31: AND ENABLED_FLAG = 'Y'
32: AND SYSDATE BETWEEN START_DATE_ACTIVE and
33: NVL(END_DATE_ACTIVE,SYSDATE)