APPS.ZX_JL_EXTRACT_PKG dependencies on JL_ZZ_AR_TX_ATT_CLS_ALL

Line 538: jl_zz_ar_tx_att_cls_all attcls,

534: WHERE DET.REQUEST_ID = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID and
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

Line 7618: FROM JL_ZZ_AR_TX_ATT_CLS_ALL cust,

7614: ELSIF l_use_site_prof <> 'Y' THEN
7615:
7616: SELECT VAL.TAX_ATTR_VALUE_CODE
7617: INTO l_cust_condition_code_tbl(p_trx_id_tbl(i))
7618: FROM JL_ZZ_AR_TX_ATT_CLS_ALL cust,
7619: JL_ZZ_AR_TX_CATEG_ALL categ,
7620: JL_ZZ_AR_TX_ATT_VAL val
7621: WHERE CUST.TAX_ATTRIBUTE_VALUE = VAL.TAX_ATTRIBUTE_VALUE and
7622: CUST.TAX_CATEGORY_ID = VAL.TAX_CATEGORY_ID and

Line 7732: jl_zz_ar_tx_att_cls_all attcls,

7728: SELECT val.tax_attr_value_code
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

Line 7926: FROM jl_zz_ar_tx_att_cls_all cls,

7922: ELSE
7923:
7924: SELECT lkp.meaning
7925: INTO l_vat_reg_stat_code_tbl(p_trx_id_tbl(i))
7926: FROM jl_zz_ar_tx_att_cls_all cls,
7927: jl_zz_ar_tx_categ_all catg,
7928: fnd_lookups lkp
7929: WHERE cls.tax_attr_class_type = 'CONTRIBUTOR_CLASS'
7930: AND cls.tax_attr_class_code = l_class_code