DBA Data[Home] [Help]

APPS.ZX_JL_EXTRACT_PKG dependencies on JL_ZZ_AR_TX_CUS_CLS_ALL

Line 7594: FROM JL_ZZ_AR_TX_CUS_CLS_ALL cust,

7590: IF l_use_site_prof = 'Y' THEN
7591:
7592: SELECT VAL.TAX_ATTR_VALUE_CODE
7593: INTO l_cust_condition_code_tbl(p_trx_id_tbl(i))
7594: FROM JL_ZZ_AR_TX_CUS_CLS_ALL cust,
7595: JL_ZZ_AR_TX_CATEG_ALL categ,
7596: JL_ZZ_AR_TX_ATT_VAL_ALL val
7597: WHERE CUST.TAX_ATTRIBUTE_VALUE = VAL.TAX_ATTRIBUTE_VALUE and
7598: CUST.TAX_CATEGORY_ID = VAL.TAX_CATEGORY_ID and

Line 7908: FROM jl_zz_ar_tx_cus_cls_all cls,

7904: IF l_use_site_prof = 'Y' THEN
7905:
7906: SELECT lkp.meaning
7907: INTO l_vat_reg_stat_code_tbl(p_trx_id_tbl(i))
7908: FROM jl_zz_ar_tx_cus_cls_all cls,
7909: jl_zz_ar_tx_categ_all catg,
7910: fnd_lookups lkp
7911: WHERE cls.tax_attr_class_code = l_class_code
7912: AND cls.tax_attribute_name = 'VAT CONT STATUS'