APPS.JAI_AR_TRX_LINES_PKG dependencies on JAI_AR_TRX_TAX_LINES

Line 119: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b

115: 'TDS',
116: 2,
117: 0) tax_type_val,
118: b.tax_type
119: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b
120: WHERE a.customer_trx_line_id = v_prev_customer_trx_line_id
121: AND a.tax_id = b.tax_id;
122:
123: CURSOR header_info_cur IS

Line 280: INSERT INTO JAI_AR_TRX_TAX_LINES

276: Where Customer_Trx_Id = v_header_id;
277:
278: ELSIF v_line_type in ('FREIGHT', 'TAX') THEN
279: FOR rec in localization_tax_info LOOP
280: INSERT INTO JAI_AR_TRX_TAX_LINES
281: (customer_trx_line_id,
282: link_to_cust_trx_line_id,
283: tax_line_no,
284: precedence_1,

Line 537: FROM JAI_AR_TRX_TAX_LINES A, JAI_CMN_TAXES_ALL B

533: WHERE A.site_use_id = NVL(p_ship_to_site_use_id, 0);
534:
535: CURSOR excise_cal_cur IS
536: SELECT A.tax_id, A.tax_rate, A.tax_amount tax_amt, b.tax_type t_type
537: FROM JAI_AR_TRX_TAX_LINES A, JAI_CMN_TAXES_ALL B
538: WHERE link_to_cust_trx_line_id = v_customer_trx_line_id
539: AND A.tax_id = B.tax_id
540: ORDER BY 1;
541:

Line 693: DELETE JAI_AR_TRX_TAX_LINES

689: (nvl(v_old_line_amount, 0) +
690: nvl(v_old_tax_tot, 0))
691: WHERE customer_trx_id = pr_old.CUSTOMER_TRX_ID;
692:
693: DELETE JAI_AR_TRX_TAX_LINES
694: WHERE LINK_TO_CUST_TRX_LINE_ID = pr_old.CUSTOMER_TRX_LINE_ID;
695:
696: DELETE JAI_AR_TRX_LINES
697: WHERE CUSTOMER_TRX_ID = pr_old.CUSTOMER_TRX_ID

Line 1133: from JAI_AR_TRX_TAX_LINES A, JAI_CMN_TAXES_ALL B

1129: WHERE customer_trx_id = v_header_id;
1130:
1131: CURSOR excise_cal_cur IS
1132: select A.tax_id, A.tax_rate, A.tax_amount tax_amt, b.tax_type t_type
1133: from JAI_AR_TRX_TAX_LINES A, JAI_CMN_TAXES_ALL B
1134: where link_to_cust_trx_line_id = pr_old.customer_trx_line_id
1135: and A.tax_id = B.tax_id
1136: order by 1;
1137:

Line 1481: from JAI_AR_TRX_TAX_LINES A, JAI_CMN_TAXES_ALL B

1477: WHERE A.site_use_id = p_ship_to_site_use_id;
1478:
1479: CURSOR excise_cal_cur IS
1480: select A.tax_id, A.tax_rate, A.tax_amount tax_amt, b.tax_type t_type
1481: from JAI_AR_TRX_TAX_LINES A, JAI_CMN_TAXES_ALL B
1482: where link_to_cust_trx_line_id = pr_old.customer_trx_line_id
1483: and A.tax_id = B.tax_id
1484: order by 1;
1485:

Line 1790: FROM JAI_AR_TRX_TAX_LINES A, JAI_CMN_TAXES_ALL B

1786: v_once_completed_flag Varchar2(1);
1787:
1788: CURSOR excise_cal_cur IS
1789: SELECT A.tax_id, A.tax_rate, A.tax_amount tax_amt, b.tax_type t_type
1790: FROM JAI_AR_TRX_TAX_LINES A, JAI_CMN_TAXES_ALL B
1791: WHERE link_to_cust_trx_line_id = v_customer_trx_line_id
1792: and A.tax_id = B.tax_id
1793: order by 1;
1794:

Line 1854: DELETE JAI_AR_TRX_TAX_LINES

1850: FROM ra_interface_lines_all il
1851: WHERE il.customer_trx_id = v_customer_trx_id
1852: AND NVL(il.interface_status, '~') <> 'P');
1853:
1854: DELETE JAI_AR_TRX_TAX_LINES
1855: WHERE LINK_TO_CUST_TRX_LINE_ID = v_customer_trx_line_id;
1856:
1857: DELETE JAI_AR_TRX_INS_LINES_T
1858: WHERE CUSTOMER_TRX_ID = v_customer_trx_id