APPS.JAI_AR_RCTA_TRIGGER_PKG dependencies on JAI_AR_TRX_TAX_LINES

Line 332: from JAI_AR_TRX_TAX_LINES

328:
329: cursor c_vat_taxes_exist
330: is
331: select 1
332: from JAI_AR_TRX_TAX_LINES
333: where link_to_cust_trx_line_id
334: in
335: (select customer_trx_line_id
336: from JAI_AR_TRX_LINES

Line 686: JAI_AR_TRX_TAX_LINES jcttl,

682: SELECT
683: regime_id ,
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

Line 728: JAI_AR_TRX_TAX_LINES jcttl,

724: IS
725: SELECT
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

Line 1121: FROM JAI_AR_TRX_TAX_LINES A ,

1117: A.func_tax_amount func_amt,
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 */

Line 1202: FROM JAI_AR_TRX_TAX_LINES A, JAI_CMN_TAXES_ALL b

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:

Line 1234: JAI_AR_TRX_TAX_LINES jrtl,

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

Line 1256: FROM JAI_AR_TRX_TAX_LINES jrctl ,

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

Line 1296: JAI_AR_TRX_TAX_LINES jcttl,

1292: SELECT
1293: regime_id ,
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

Line 1317: JAI_AR_TRX_TAX_LINES jcttl,

1313: IS
1314: SELECT
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

Line 2457: FROM JAI_AR_TRX_TAX_LINES A , JAI_CMN_TAXES_ALL B

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:

Line 2518: JAI_AR_TRX_TAX_LINES jcttl,

2514: IS
2515: SELECT
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

Line 2942: SQL STATEMENT JAI_AR_TRX_TAX_LINES MODIFY PRECEDENCE IS ADDED FROM 6 TO 10

2938: CURSOR GC_GET_REGIME_ID ADD CURSOR FOR GETTING REGIME ID FOR TCS
2939: VARIABLE LV_PROCESS_FLAG ADD VARIABLE LV_PROCESS_FLAG IS PROCESS FLAG
2940: VARIABLE LV_PROCESS_MESSAGE ADD VARIABLE LV_PROCESS_MESSAGE IS PROCESS MESSAGE RETURN BY CALLING OBJECT IN RESPONSE
2941: CURSOR TAX_INFO_CUR MODIFY PRECEDENCE IS ADDED FROM 6 TO 10
2942: SQL STATEMENT JAI_AR_TRX_TAX_LINES MODIFY PRECEDENCE IS ADDED FROM 6 TO 10
2943: 3. 27-Feb-2007 CSahoo for Bug 5390583, File Version 120.5 Forward Porting of 11i BUG 5357400
2944: When a change is done in the invoice currency code from the front end
2945: the change is being reflected in the JAI_AR_TRXS table.
2946: Added a IF clause for the same.

Line 3049: DELETE JAI_AR_TRX_TAX_LINES

3045: v_price_list_val := '';
3046: v_converted_rate := '';
3047: v_line_tax_amount := 0;
3048:
3049: DELETE JAI_AR_TRX_TAX_LINES
3050: WHERE LINK_TO_CUST_TRX_LINE_ID = Rec.CUSTOMER_TRX_LINE_ID;
3051:
3052: IF v_customer_id IS NOT NULL AND v_address_id IS NOT NULL
3053: THEN

Line 3398: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b

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:

Line 3500: INSERT INTO JAI_AR_TRX_TAX_LINES(customer_trx_line_id, link_to_cust_trx_line_id, tax_line_no,

3496: rec1.tax_amount := 0;
3497: rec1.base_tax_amount := 0;
3498: rec1.func_tax_amount := 0;
3499: END IF;
3500: INSERT INTO JAI_AR_TRX_TAX_LINES(customer_trx_line_id, link_to_cust_trx_line_id, tax_line_no,
3501: precedence_1,precedence_2, precedence_3, precedence_4,precedence_5,
3502: precedence_6,precedence_7, precedence_8, precedence_9,precedence_10, -- Date 06/12/2006 Bug 5228046 added by SACSETHI
3503: tax_id, tax_rate, qty_rate, uom,
3504: tax_amount, base_tax_amount, func_tax_amount,