[Home] [Help]
337: where customer_trx_id = pr_new.customer_trx_id
338: )
339: and tax_id in
340: (select tax_id
341: from JAI_CMN_TAXES_ALL
342: where vat_flag = 'Y'
343: and org_id = pr_new.org_id
344: )
345: ;
684: regime_code
685: FROM
686: JAI_AR_TRX_TAX_LINES jcttl,
687: JAI_AR_TRX_LINES jctl,
688: JAI_CMN_TAXES_ALL jtc ,
689: jai_regime_tax_types_v jrttv
690: WHERE
691: jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id AND
692: jctl.customer_trx_id = pr_new.customer_trx_id AND
719: /*
720: || Added by kunkumar for bug#5645003
721: || Check if only 'VAT REVERSAL' tax type is present in ja_in_ra_cust_trx_tax_lines
722: */
723: CURSOR c_chk_vat_reversal (cp_tax_type jai_cmn_taxes_all.tax_type%TYPE )
724: IS
725: SELECT
726: 1
727: FROM
726: 1
727: FROM
728: JAI_AR_TRX_TAX_LINES jcttl,
729: JAI_AR_TRX_LINES jctl,
730: JAI_CMN_TAXES_ALL jtc
731: WHERE
732: jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id AND
733: jctl.customer_trx_id = pr_new.customer_trx_id AND
734: jcttl.tax_id = jtc.tax_id AND
1118: b.tax_type t_type,
1119: b.stform_type,
1120: A.tax_line_no
1121: FROM JAI_AR_TRX_TAX_LINES A ,
1122: JAI_CMN_TAXES_ALL B,
1123: JAI_INV_ITM_SETUPS C
1124: WHERE link_to_cust_trx_line_id = p_line_id
1125: AND b.tax_type IN --('Excise','Addl. Excise','Other Excise') /* Modified by Ramananda for removal of SQL LITERALs */
1126: (jai_constants.tax_type_excise,jai_constants.tax_type_exc_additional,jai_constants.tax_type_exc_other)
1198: (location_id is NULL and v_location_id is NULL)); /* Modified by Ramananda for removal of SQL LITERALs */
1199:
1200: CURSOR for_modvat_tax_rate(p_cust_trx_line_id NUMBER) IS
1201: SELECT A.tax_rate
1202: FROM JAI_AR_TRX_TAX_LINES A, JAI_CMN_TAXES_ALL b
1203: WHERE A.tax_id = b.tax_id
1204: AND A.link_to_cust_trx_line_id = p_cust_trx_line_id
1205: AND b.tax_type = jai_constants.tax_type_modvat_recovery ; --'Modvat Recovery';
1206:
1231: SELECT nvl(sum(jrtl.func_tax_amount),0)
1232: FROM JAI_AR_TRXS jtrx,
1233: JAI_AR_TRX_LINES jtl,
1234: JAI_AR_TRX_TAX_LINES jrtl,
1235: JAI_CMN_TAXES_ALL jtc ,
1236: JAI_INV_ITM_SETUPS jmtl
1237: WHERE jrtl.tax_id = jtc.tax_id
1238: AND jtrx.customer_trx_id = jtl.customer_Trx_id
1239: AND jrtl.link_to_cust_trx_line_id = jtl.customer_trx_line_id
1253:
1254: CURSOR c_cess_amount is
1255: SELECT NVL(SUM(jrctl.func_tax_amount),0) tax_amount
1256: FROM JAI_AR_TRX_TAX_LINES jrctl ,
1257: JAI_CMN_TAXES_ALL jtc
1258: WHERE jtc.tax_id = jrctl.tax_id
1259: AND link_to_cust_trx_line_id IN
1260: (SELECT customer_trx_line_id
1261: FROM JAI_AR_TRX_LINES
1294: regime_code
1295: FROM
1296: JAI_AR_TRX_TAX_LINES jcttl,
1297: JAI_AR_TRX_LINES jctl,
1298: JAI_CMN_TAXES_ALL jtc ,
1299: jai_regime_tax_types_v jrttv
1300: WHERE
1301: jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id AND
1302: jctl.customer_trx_id = pr_new.customer_trx_id AND
1308: /*
1309: || Added by kunkumar for bug#5645003
1310: || Check if only 'VAT REVERSAL' tax type is present in ja_in_ra_cust_trx_tax_lines
1311: */
1312: CURSOR c_chk_vat_reversal (cp_tax_type jai_cmn_taxes_all.tax_type%TYPE )
1313: IS
1314: SELECT
1315: 1
1316: FROM
1315: 1
1316: FROM
1317: JAI_AR_TRX_TAX_LINES jcttl,
1318: JAI_AR_TRX_LINES jctl,
1319: JAI_CMN_TAXES_ALL jtc
1320: WHERE
1321: jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id AND
1322: jctl.customer_trx_id = pr_new.customer_trx_id AND
1323: jcttl.tax_id = jtc.tax_id AND
2453: --AND ACCOUNT_CLASS IN ('TAX','FREIGHT');
2454:
2455: CURSOR TAX_TYPE_CUR(p_customer_trx_line_id Number) IS
2456: SELECT A.tax_id taxid, A.tax_rate, A.uom uom,A.tax_amount tax_amt,b.tax_type t_type,A.customer_trx_line_id line_id , a.tax_line_no
2457: FROM JAI_AR_TRX_TAX_LINES A , JAI_CMN_TAXES_ALL B
2458: WHERE link_to_cust_trx_line_id = p_customer_trx_line_id
2459: AND A.tax_id = B.tax_id
2460: ORDER BY 1;
2461:
2465: /* Added by Ramananda for bug#4468353 , end */
2466:
2467: CURSOR TAX_CCID_CUR(p_tax_id IN NUMBER) IS
2468: SELECT tax_account_id
2469: FROM JAI_CMN_TAXES_ALL B
2470: WHERE B.tax_id = p_tax_id ;
2471:
2472:
2473: CURSOR SO_AR_HDR_INFO IS
2509: /*
2510: || Added by kunkumar for bug#5645003
2511: || Check if only 'VAT REVERSAL' tax type is present in ja_in_ra_cust_trx_tax_lines
2512: */
2513: CURSOR c_chk_vat_reversal (cp_tax_type jai_cmn_taxes_all.tax_type%TYPE )
2514: IS
2515: SELECT
2516: 1
2517: FROM
2516: 1
2517: FROM
2518: JAI_AR_TRX_TAX_LINES jcttl,
2519: JAI_AR_TRX_LINES jctl,
2520: JAI_CMN_TAXES_ALL jtc
2521: WHERE
2522: jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id AND
2523: jctl.customer_trx_id = pr_new.customer_trx_id AND
2524: jcttl.tax_id = jtc.tax_id AND
2872: LN_THRESHOLD_SLAB_ID JAI_AP_TDS_THHOLD_SLABS.THRESHOLD_SLAB_ID%TYPE;
2873: LN_THRESHOLD_TAX_CAT_ID JAI_AP_TDS_THHOLD_TAXES.TAX_CATEGORY_ID%TYPE;
2874:
2875: CURSOR GC_CHK_RGM_TAX_EXISTS ( CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE
2876: , CP_RGM_TAX_TYPE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE
2877: , CP_TAX_CATEGORY_ID JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_ID%TYPE
2878: )
2879: IS
2880: SELECT COUNT(1)
2878: )
2879: IS
2880: SELECT COUNT(1)
2881: FROM JAI_CMN_TAX_CTG_LINES CATL
2882: ,JAI_CMN_TAXES_ALL CODES
2883: ,JAI_REGIME_TAX_TYPES_V JRTTV
2884: WHERE CATL.TAX_CATEGORY_ID = CP_TAX_CATEGORY_ID
2885: AND CATL.TAX_ID = CODES.TAX_ID
2886: AND CODES.TAX_TYPE = JRTTV.TAX_TYPE
3394: a.precedence_1,a.precedence_2, a.precedence_3, a.precedence_4,a.precedence_5,
3395: a.precedence_6,a.precedence_7, a.precedence_8, a.precedence_9,a.precedence_10, -- Date 06/12/2006 Bug 5228046 added by SACSETHI
3396: a.tax_id, a.tax_rate, a.qty_rate, a.uom, a.tax_amount, a.base_tax_amount, a.func_tax_amount,
3397: b.end_date valid_date, b.tax_type
3398: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b
3399: WHERE a.link_to_cust_trx_line_id = p_parent_line_id
3400: AND a.tax_id = b.tax_id
3401: ORDER BY a.tax_line_no;
3402: