DBA Data[Home] [Help]

APPS.ZX_JA_EXTRACT_PKG dependencies on ZX_FC_CODES_DENORM_B

Line 2108: FROM ZX_FC_CODES_DENORM_B

2104: IF P_LOOKUP_TYPE = 'JATW_GUI_TYPE' then
2105: BEGIN
2106: SELECT CLASSIFICATION_NAME
2107: INTO x_lookup_meaning
2108: FROM ZX_FC_CODES_DENORM_B
2109: WHERE CLASSIFICATION_TYPE_CODE = 'DOCUMENT_SUBTYPE' and
2110: -- CLASSIFICATION_CODE_LEVEL = 2 and --Bug5453806
2111: CONCAT_CLASSIF_CODE = P_LOOKUP_CODE
2112: AND LANGUAGE = userenv('LANG') --Bug 5453957

Line 2138: FROM ZX_FC_CODES_DENORM_B

2134: ELSIF P_LOOKUP_TYPE = 'JATW_DEDUCTIBLE_TYPE' then
2135: BEGIN
2136: SELECT CLASSIFICATION_NAME
2137: INTO x_lookup_meaning
2138: FROM ZX_FC_CODES_DENORM_B
2139: WHERE CLASSIFICATION_TYPE_CODE = 'TRX_BUSINESS_CATEGORY' and
2140: -- CLASSIFICATION_CODE_LEVEL = 3 and --Bug5453806
2141: CONCAT_CLASSIF_CODE = P_LOOKUP_CODE
2142: AND LANGUAGE = userenv('LANG') --Bug 5453957