APPS.JAI_AR_IMPORT_SYNC_PKG dependencies on JAI_AR_TRX_TAX_LINES

Line 106: from JAI_AR_TRX_TAX_LINES

102:
103: cursor c_vat_taxes_exist
104: is
105: select 1
106: from JAI_AR_TRX_TAX_LINES
107: where link_to_cust_trx_line_id
108: in
109: (select customer_trx_line_id
110: from JAI_AR_TRX_LINES

Line 739: FROM JAI_AR_TRX_TAX_LINES A ,

735: A.func_tax_amount func_amt,
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')

Line 820: FROM JAI_AR_TRX_TAX_LINES A, JAI_CMN_TAXES_ALL b

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:

Line 847: JAI_AR_TRX_TAX_LINES jrtl,

843: CURSOR c_total_Excise_amt IS
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

Line 869: FROM JAI_AR_TRX_TAX_LINES jrctl ,

865: v_total_excise_amt NUMBER :=0;
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

Line 918: JAI_AR_TRX_TAX_LINES jcttl,

914: SELECT
915: regime_id ,
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

Line 939: JAI_AR_TRX_TAX_LINES jcttl,

935: IS
936: SELECT
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

Line 1039: JAI_AR_TRX_TAX_LINES jcttl,

1035: IS
1036: SELECT regime_id ,
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

Line 2227: JAI_AR_TRX_TAX_LINES jcttl,

2223: IS
2224: SELECT regime_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

Line 2259: FROM JAI_AR_TRX_TAX_LINES jcttl,

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,
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

Line 2317: JAI_AR_TRX_TAX_LINES jcttl ,

2313: jtc.tax_type ,
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