[Home] [Help]
58: --------------------------------------------------------------------------------------
59: PROCEDURE PUNCH_SETTLEMENT_ID ARGUMENT ADDED P_TAN_NO IS ADDED
60: PROCEDURE PUNCH_SETTLEMENT_ID ARGUMENT ADDED P_ITEM_CLASSIFICATION IS ADDED
61: PROCEDURE PUNCH_SETTLEMENT_ID CODE ADDED UPDATATION OF SETTLEMENT_ID IN TABLE
62: JAI_RGM_REFS_ALL FOR TCS
63: PROCEDURE GET_BALANCES ARGUMENT ADDED P_ITEM_CLASSIFICATIONIS ADDED
64: PROCEDURE GET_BALANCES CURSOR ADDED CUR_REGIME_CODE IS ADDED
65: PROCEDURE GET_BALANCES CODE ADDED PROCEDURE CALCULATE_RGM_BALANCES FOR TCS
66: PROCEDURE CALCULATE_RGM_BALANCES NEW CREATED NEWLY PROCEDURE ADDED FOR TCS
862: AND trunc(transaction_date) <= p_balance_date /*bug 9445836*/
863: AND settlement_id IS NULL;
864:
865: ELSIF lv_regime = jai_constants.tcs_regime THEN
866: UPDATE JAI_RGM_REFS_ALL
867: SET SETTLEMENT_ID = P_SETTLEMENT_ID
868: WHERE ORG_TAN_NO = P_TAN_NO AND
869: ITEM_CLASSIFICATION = P_ITEM_CLASSIFICATION AND
870: TRUNC(SOURCE_DOCUMENT_DATE) <= P_BALANCE_DATE AND
1790: AND jbal.settlement_id <> p_settlement_id;
1791:
1792: CURSOR cur_inv_payment_tcs(cp_organization_type VARCHAR2, cp_organization_id NUMBER, cp_location_id NUMBER) IS
1793: SELECT SUM(total_tax_amt * decode(sign(total_tax_amt), -1, -1, 0)) -- Negative amount converted to positive and taken as credit amount
1794: FROM jai_rgm_refs_all
1795: WHERE org_tan_no = P_TAN_NO
1796: --AND source_document_type = 'Invoice Payment' --mmurtuza need to discuss
1797: AND settlement_id =
1798: (SELECT MAX(jbal.settlement_id)
1849: DECODE(JRT.TAX_TYPE,'TCS_SURCHARGE_CESS','TCS_CESS',JRT.TAX_TYPE) TAX_TYPE,
1850: JRR.ORGANIZATION_ID,
1851: JRR.LOCATION_ID, --added by mmurtuza for bug 12641455
1852: JRR.REGIME_ID
1853: FROM JAI_RGM_REFS_ALL JRR,
1854: JAI_RGM_TAXES JRT,
1855: --JAI_RGM_ORG_REGNS_V JOR --commented for bug# 9005474
1856: JAI_RGM_REGISTRATIONS JOR --added for bug#9005474
1857: WHERE JRR.TRX_REF_ID = JRT.TRX_REF_ID