APPS.JAI_AP_DTC_GENERATION_PKG dependencies on JAI_CMN_TAX_CTG_LINES

Line 2853: JAI_CMN_TAX_CTG_LINES CATE

2849: CATE.PRECEDENCE_8,
2850: CATE.PRECEDENCE_9,
2851: CATE.PRECEDENCE_10
2852: FROM JAI_CMN_TAXES_ALL TAX,
2853: JAI_CMN_TAX_CTG_LINES CATE
2854: WHERE CATE.TAX_CATEGORY_ID = cn_tax_category_id
2855: AND TAX.TAX_ID = CATE.TAX_ID;
2856:
2857: CURSOR c_get_already_applied_new(

Line 5211: from JAI_CMN_TAX_CTG_LINES cat,

5207:
5208: cursor chk_surcharge_tax(cn_category_id number)
5209: is
5210: select tax.tax_id,tax.tax_rate, tax.section_code
5211: from JAI_CMN_TAX_CTG_LINES cat,
5212: JAI_CMN_TAXES_ALL tax
5213: where cat.tax_id = tax.tax_id
5214: and tax.tax_type in ('TDS_SURCHARGE')
5215: and cat.tax_category_id = cn_category_id;

Line 5259: FROM JAI_CMN_TAX_CTG_LINES jctcl

5255: --Added by Chong for bug#15976304 20121212 Start
5256: ------------------------------------------------
5257: AND NOT EXISTS(
5258: SELECT 1
5259: FROM JAI_CMN_TAX_CTG_LINES jctcl
5260: ,jai_cmn_taxes_all jcta
5261: WHERE jctcl.tax_category_id = jattt.tax_category_id
5262: AND jctcl.tax_id = jcta.tax_id
5263: AND jcta.tax_type = 'TDS_SURCHARGE'

Line 5405: FROM JAI_CMN_TAX_CTG_LINES

5401: ln_flag := 0;
5402:
5403: FOR R_TAX_CTG_LINES IN(
5404: SELECT *
5405: FROM JAI_CMN_TAX_CTG_LINES
5406: WHERE TAX_CATEGORY_ID = nvl(TRAN_TAB(i).TAX_CATEGORY_ID, LN_TAX_CATEGORY_ID)
5407: ORDER BY LINE_NO
5408: )
5409: LOOP