DBA Data[Home] [Help]

APPS.ZX_DEFAULT_AUTOMATION_PKG dependencies on ZX_FC_DOCUMENT_FISCAL_V

Line 389: l_document_sub_type ZX_FC_DOCUMENT_FISCAL_V.CLASSIFICATION_CODE%TYPE;

385: l_product_category ZX_FC_COUNTRY_DEFAULTS.PRODUCT_CATEG_DEFAULT%TYPE;
386: l_product_fisc_class ZX_FC_TYPES_B.CLASSIFICATION_TYPE_CODE%TYPE;
387: l_intended_use ZX_FC_TYPES_B.CLASSIFICATION_TYPE_CODE%TYPE;
388: l_trx_date DATE;
389: l_document_sub_type ZX_FC_DOCUMENT_FISCAL_V.CLASSIFICATION_CODE%TYPE;
390: l_user_defined_fisc_class ZX_FC_CODES_B.CLASSIFICATION_CODE%TYPE;
391: l_product_type FND_LOOKUPS.LOOKUP_CODE%TYPE;
392: l_init_msg_list VARCHAR2(1);
393: l_commit VARCHAR2(1);

Line 553: -- FROM ZX_FC_DOCUMENT_FISCAL_V

549: END IF;
550:
551: -- BEGIN
552: -- SELECT classification_code INTO l_document_sub_type
553: -- FROM ZX_FC_DOCUMENT_FISCAL_V
554: -- WHERE l_trx_date between effective_from and nvl(effective_to, l_trx_date)
555: -- AND (country_code = l_country_code OR country_code IS NULL);
556: -- EXCEPTION
557: -- WHEN NO_DATA_FOUND THEN