DBA Data[Home] [Help]

APPS.ZX_JL_EXTRACT_PKG dependencies on JL_ZZ_AR_TX_ATT_VAL_ALL

Line 569: jl_zz_ar_tx_att_val_all val

565: NOT EXISTS
566: (SELECT 1
567: FROM jl_zz_ar_tx_categ_all catg,
568: jl_zz_ar_tx_att_cls_all attcls,
569: jl_zz_ar_tx_att_val_all val
570: WHERE attcls.tax_attribute_value = val.tax_attribute_value
571: AND attcls.tax_category_id = val.tax_category_id
572: AND attcls.tax_attribute_name = val.tax_attribute_name
573: AND val.tax_attribute_type = 'TRANSACTION_ATTRIBUTE'

Line 8070: JL_ZZ_AR_TX_ATT_VAL_ALL val

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

Line 8214: jl_zz_ar_tx_att_val_all val

8210: INTO l_dgi_tax_regime_code_tbl(k)
8211: FROM zx_lines lines,
8212: jl_zz_ar_tx_categ_all catg,
8213: jl_zz_ar_tx_att_cls_all attcls,
8214: jl_zz_ar_tx_att_val_all val
8215: WHERE catg.tax_category = P_VAT_PERCEP_TAX
8216: ANd catg.tax_category = lines.tax
8217: AND attcls.tax_attribute_value = val.tax_attribute_value
8218: AND attcls.tax_category_id = val.tax_category_id