APPS.ZX_JL_EXTRACT_PKG dependencies on JL_ZZ_AR_TX_ATT_VAL_ALL

Line 539: jl_zz_ar_tx_att_val_all val

535: NOT EXISTS
536: (SELECT 1
537: FROM jl_zz_ar_tx_categ_all catg,
538: jl_zz_ar_tx_att_cls_all attcls,
539: jl_zz_ar_tx_att_val_all val
540: WHERE attcls.tax_attribute_value = val.tax_attribute_value
541: AND attcls.tax_category_id = val.tax_category_id
542: AND attcls.tax_attribute_name = val.tax_attribute_name
543: AND val.tax_attribute_type = 'TRANSACTION_ATTRIBUTE'

Line 7596: JL_ZZ_AR_TX_ATT_VAL_ALL val

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
7599: CUST.TAX_CATEGORY_ID = CATEG.TAX_CATEGORY_ID and
7600: CUST.TAX_ATTRIBUTE_NAME = VAL.TAX_ATTRIBUTE_NAME and

Line 7733: jl_zz_ar_tx_att_val_all val

7729: INTO l_dgi_tax_regime_code_tbl(p_trx_line_id_tbl(i))
7730: FROM zx_lines lines,
7731: jl_zz_ar_tx_categ_all catg,
7732: jl_zz_ar_tx_att_cls_all attcls,
7733: jl_zz_ar_tx_att_val_all val
7734: WHERE catg.tax_category = P_VAT_PERCEP_TAX
7735: ANd catg.tax_category = lines.tax
7736: AND attcls.tax_attribute_value = val.tax_attribute_value
7737: AND attcls.tax_category_id = val.tax_category_id