[Home] [Help]
1537: CURSOR cur_excise_taxes_exist(pn_customer_trx_line_id NUMBER)
1538: IS
1539: SELECT
1540: 'Y'
1541: FROM dual
1542: WHERE EXISTS
1543: (SELECT 1
1544: FROM JAI_AR_TRX_TAX_LINES jcttl,
1545: JAI_AR_TRX_LINES jctl,
2803: */
2804: --Commented by Chong.Lei for POT code port end
2805: -- Added by Chong.Lei for POT code port begin
2806: ------------------------------------------------------------------------------------
2807: /*Bug 12805386 - Fetch Effective Date of Point of Taxation only if Organization Type is either 'INDIVIDUALS' or 'PARTNERSHIP FIRM'
2808: or 'PROPRIETARY FIRM' and if the Service Type is one mentioned in Rule 7 of Point of Taxation Rules 2011 i.e
2809: 105-p, 105-q, 105-s, 105-t, 105-u, 105-za, 105-zzzzm*/
2810: CURSOR c_get_st_accrual_date(p_regime_id NUMBER, p_organization_id NUMBER, p_location_id NUMBER) IS
2811: select to_date(attribute_value, 'DD/MM/YYYY')
4175: FROM jai_regime_tax_types_v jrttv1
4176: WHERE jrttv1.regime_code = jai_constants.vat_regime
4177: UNION
4178: SELECT 'VAT REVERSAL' tax_type
4179: FROM DUAL
4180: ) jrttv
4181: WHERE
4182: jctl.customer_trx_id = pr_new.customer_trx_id AND
4183: jctl.customer_trx_line_id = jcttl.link_to_cust_trx_line_id AND
4632:
4633: FOR rec in LINES_INFO_CUR(v_parent_header_id)
4634: LOOP
4635:
4636: -- SELECT ra_customer_trx_lines_s.nextval INTO v_customer_trx_line_id FROM Dual;
4637:
4638: INSERT INTO JAI_AR_TRX_LINES
4639: (customer_trx_line_id, line_number,
4640: customer_trx_id, description,