[Home] [Help]
111: where customer_trx_id = pr_new.customer_trx_id
112: )
113: and tax_id in
114: (select tax_id
115: from JAI_CMN_TAXES_ALL
116: where vat_flag = 'Y'
117: and org_id = pr_new.org_id
118: )
119: ;
736: b.tax_type t_type,
737: b.stform_type,
738: A.tax_line_no
739: FROM JAI_AR_TRX_TAX_LINES A ,
740: JAI_CMN_TAXES_ALL B,
741: JAI_INV_ITM_SETUPS C
742: WHERE link_to_cust_trx_line_id = p_line_id
743: AND b.tax_type IN --('Excise','Addl. Excise','Other Excise')
744: (jai_constants.tax_type_excise,jai_constants.tax_type_exc_additional,jai_constants.tax_type_exc_other)
816: (location_id is NULL and v_location_id is NULL));
817:
818: CURSOR for_modvat_tax_rate(p_cust_trx_line_id NUMBER) IS
819: SELECT A.tax_rate
820: FROM JAI_AR_TRX_TAX_LINES A, JAI_CMN_TAXES_ALL b
821: WHERE A.tax_id = b.tax_id
822: AND A.link_to_cust_trx_line_id = p_cust_trx_line_id
823: AND b.tax_type = jai_constants.tax_type_modvat_recovery ; --'Modvat Recovery';
824:
844: SELECT nvl(sum(jrtl.func_tax_amount),0)
845: FROM JAI_AR_TRXS jtrx,
846: JAI_AR_TRX_LINES jtl,
847: JAI_AR_TRX_TAX_LINES jrtl,
848: JAI_CMN_TAXES_ALL jtc ,
849: JAI_INV_ITM_SETUPS jmtl
850: WHERE jrtl.tax_id = jtc.tax_id
851: AND jtrx.customer_trx_id = jtl.customer_Trx_id
852: AND jrtl.link_to_cust_trx_line_id = jtl.customer_trx_line_id
866:
867: CURSOR c_cess_amount is
868: SELECT NVL(SUM(jrctl.func_tax_amount),0) tax_amount
869: FROM JAI_AR_TRX_TAX_LINES jrctl ,
870: JAI_CMN_TAXES_ALL jtc
871: WHERE jtc.tax_id = jrctl.tax_id
872: AND link_to_cust_trx_line_id IN
873: (SELECT customer_trx_line_id
874: FROM JAI_AR_TRX_LINES
916: regime_code
917: FROM
918: JAI_AR_TRX_TAX_LINES jcttl,
919: JAI_AR_TRX_LINES jctl,
920: JAI_CMN_TAXES_ALL jtc ,
921: jai_regime_tax_types_v jrttv
922: WHERE
923: jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id AND
924: jctl.customer_trx_id = pr_new.customer_trx_id AND
930: /*
931: ||
932: || Check if only 'VAT REVERSAL' tax type is present in ja_in_ra_cust_trx_tax_lines
933: */
934: CURSOR c_chk_vat_reversal (cp_tax_type jai_cmn_taxes_all.tax_type%TYPE )
935: IS
936: SELECT
937: 1
938: FROM
937: 1
938: FROM
939: JAI_AR_TRX_TAX_LINES jcttl,
940: JAI_AR_TRX_LINES jctl,
941: JAI_CMN_TAXES_ALL jtc
942: WHERE
943: jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id AND
944: jctl.customer_trx_id = pr_new.customer_trx_id AND
945: jcttl.tax_id = jtc.tax_id AND
1037: regime_code
1038: FROM
1039: JAI_AR_TRX_TAX_LINES jcttl,
1040: JAI_AR_TRX_LINES jctl,
1041: JAI_CMN_TAXES_ALL jtc ,
1042: jai_regime_tax_types_v jrttv
1043: WHERE jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id
1044: AND jctl.customer_trx_id = pr_new.customer_trx_id
1045: AND jcttl.tax_id = jtc.tax_id
2225: regime_code
2226: FROM
2227: JAI_AR_TRX_TAX_LINES jcttl,
2228: JAI_AR_TRX_LINES jctl,
2229: JAI_CMN_TAXES_ALL jtc ,
2230: jai_regime_tax_types_v jrttv
2231: WHERE jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id
2232: AND jctl.customer_trx_id = pr_new.customer_trx_id
2233: AND jcttl.tax_id = jtc.tax_id
2252:
2253: /*
2254: || Check if only 'VAT REVERSAL' tax type is present in ja_in_ra_cust_trx_tax_lines
2255: */
2256: CURSOR c_chk_vat_reversal (cp_tax_type jai_cmn_taxes_all.tax_type%TYPE )
2257: IS
2258: SELECT 1
2259: FROM JAI_AR_TRX_TAX_LINES jcttl,
2260: JAI_AR_TRX_LINES jctl,
2257: IS
2258: SELECT 1
2259: FROM JAI_AR_TRX_TAX_LINES jcttl,
2260: JAI_AR_TRX_LINES jctl,
2261: JAI_CMN_TAXES_ALL jtc
2262: WHERE jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id
2263: AND jctl.customer_trx_id = pr_new.customer_trx_id
2264: AND jcttl.tax_id = jtc.tax_id
2265: AND jtc.org_id = pr_new.org_id
2314: jcttl.tax_rate
2315: FROM
2316: JAI_AR_TRX_LINES jctl ,
2317: JAI_AR_TRX_TAX_LINES jcttl ,
2318: JAI_CMN_TAXES_ALL jtc ,
2319: (
2320: SELECT jrttv1.tax_type tax_type
2321: FROM jai_regime_tax_types_v jrttv1
2322: WHERE jrttv1.regime_code = jai_constants.vat_regime