APPS.JAI_CMN_RGM_TAX_DIST_PKG dependencies on JAI_RGM_REFS_ALL

Line 62: JAI_RGM_REFS_ALL FOR TCS

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

Line 453: UPDATE JAI_RGM_REFS_ALL

449: AND trunc(transaction_date) BETWEEN nvl(jai_cmn_rgm_settlement_pkg.get_last_settlement_date(p_regime_id,organization_id,location_id),g_start_date) AND p_balance_date
450: AND settlement_id IS NULL;
451:
452: ELSIF lv_regime = jai_constants.tcs_regime THEN
453: UPDATE JAI_RGM_REFS_ALL
454: SET SETTLEMENT_ID = P_SETTLEMENT_ID
455: WHERE ORG_TAN_NO = P_TAN_NO AND
456: ITEM_CLASSIFICATION = P_ITEM_CLASSIFICATION AND
457: TRUNC(SOURCE_DOCUMENT_DATE) <= P_BALANCE_DATE AND

Line 1102: FROM JAI_RGM_REFS_ALL JRR,

1098: SUM(DECODE(SIGN(JRT.TAX_AMT),1,JRT.TAX_AMT,-1,0)) DEBIT_AMOUNT,
1099: DECODE(JRT.TAX_TYPE,'TCS_SURCHARGE_CESS','TCS_CESS',JRT.TAX_TYPE) TAX_TYPE,
1100: JRR.ORGANIZATION_ID,
1101: JRR.REGIME_ID
1102: FROM JAI_RGM_REFS_ALL JRR,
1103: JAI_RGM_TAXES JRT,
1104: JAI_RGM_ORG_REGNS_V JOR
1105: WHERE JRR.TRX_REF_ID = JRT.TRX_REF_ID
1106: AND JRR.ORGANIZATION_ID = JOR.ORGANIZATION_ID