DBA Data[Home] [Help]

APPS.ZX_JL_EXTRACT_PKG dependencies on JL_ZZ_AR_TX_CUS_CLS_ALL

Line 8068: FROM JL_ZZ_AR_TX_CUS_CLS_ALL cust,

8064: IF l_use_site_prof = 'Y' THEN
8065:
8066: SELECT VAL.TAX_ATTR_VALUE_CODE
8067: INTO l_cust_condition_code_tbl(p_trx_id_tbl(i))
8068: FROM JL_ZZ_AR_TX_CUS_CLS_ALL cust,
8069: JL_ZZ_AR_TX_CATEG_ALL categ,
8070: JL_ZZ_AR_TX_ATT_VAL_ALL val
8071: WHERE CUST.TAX_ATTRIBUTE_VALUE = VAL.TAX_ATTRIBUTE_VALUE and
8072: CUST.TAX_CATEGORY_ID = VAL.TAX_CATEGORY_ID and

Line 8384: FROM jl_zz_ar_tx_cus_cls_all cls,

8380: IF l_use_site_prof = 'Y' THEN
8381:
8382: SELECT lkp.meaning
8383: INTO l_vat_reg_stat_code_tbl(p_trx_id_tbl(i))
8384: FROM jl_zz_ar_tx_cus_cls_all cls,
8385: jl_zz_ar_tx_categ_all catg,
8386: fnd_lookups lkp
8387: WHERE cls.tax_attr_class_code = l_class_code
8388: AND cls.tax_attribute_name = 'VAT CONT STATUS'