eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_JAINRGCR_XMLP_PKG dependencies on JAI_RGM_TRX_RECORDS

Line 111: JAI_RGM_TRX_RECORDS

107: SELECT
108: NVL(SUM(DEBIT_AMOUNT)
109: ,0)
110: FROM
111: JAI_RGM_TRX_RECORDS
112: WHERE SOURCE = LV_SERVICE_SRC_DISTRIBUTE_OUT
113: AND REGIME_CODE = LV_SERVICE_REGIME
114: AND TAX_TYPE IN ( LV_TAX_TYPE_SERVICE , LV_TAX_TYPE_SERVICE_EDU_CESS , LV_TAX_TYPE_SH_SER_EDU_CESS )
115: AND REGIME_PRIMARY_REGNO = P_REGM_PRMY_REGN

Line 126: JAI_RGM_TRX_RECORDS

122: SELECT
123: NVL(SUM(DEBIT_AMOUNT)
124: ,0)
125: FROM
126: JAI_RGM_TRX_RECORDS
127: WHERE SOURCE = CP_SOURCE
128: AND REGIME_CODE = LV_SERVICE_REGIME
129: AND TAX_TYPE IN ( LV_TAX_TYPE_SERVICE , LV_TAX_TYPE_SERVICE_EDU_CESS , LV_TAX_TYPE_SH_SER_EDU_CESS )
130: AND SOURCE_TRX_TYPE IN ( LV_ADJUST_LIABILITY , LV_LIABILITY )

Line 137: CURSOR CUR_PAYMENT(CP_SOURCE IN JAI_RGM_TRX_RECORDS.SOURCE%TYPE,CP_TRX_TYPE IN JAI_RGM_TRX_RECORDS.SOURCE_TRX_TYPE%TYPE) IS

133: ,SYSDATE) ) BETWEEN ( NVL(P_FROM_DATE
134: ,SYSDATE) )
135: AND ( NVL(P_TO_DATE
136: ,SYSDATE) );
137: CURSOR CUR_PAYMENT(CP_SOURCE IN JAI_RGM_TRX_RECORDS.SOURCE%TYPE,CP_TRX_TYPE IN JAI_RGM_TRX_RECORDS.SOURCE_TRX_TYPE%TYPE) IS
138: SELECT
139: NVL(SUM(DEBIT_AMOUNT)
140: ,0)
141: FROM

Line 142: JAI_RGM_TRX_RECORDS

138: SELECT
139: NVL(SUM(DEBIT_AMOUNT)
140: ,0)
141: FROM
142: JAI_RGM_TRX_RECORDS
143: WHERE SOURCE = CP_SOURCE
144: AND REGIME_CODE = LV_SERVICE_REGIME
145: AND TAX_TYPE IN ( LV_TAX_TYPE_SERVICE , LV_TAX_TYPE_SERVICE_EDU_CESS , LV_TAX_TYPE_SH_SER_EDU_CESS )
146: AND SOURCE_TRX_TYPE = CP_TRX_TYPE

Line 215: JAI_RGM_TRX_RECORDS

211: CURSOR CUR_DIST_IN IS
212: SELECT
213: SUM(CREDIT_AMOUNT)
214: FROM
215: JAI_RGM_TRX_RECORDS
216: WHERE SOURCE = LV_SERVICE_SRC_DISTRIBUTE_IN
217: AND REGIME_CODE = LV_SERVICE_REGIME
218: AND TAX_TYPE IN ( LV_TAX_TYPE_SERVICE , LV_TAX_TYPE_SERVICE_EDU_CESS , LV_TAX_TYPE_SH_SER_EDU_CESS )
219: AND REGIME_PRIMARY_REGNO = P_REGM_PRMY_REGN

Line 223: CURSOR CUR_MANUAL_IN(CP_SOURCE IN JAI_RGM_TRX_RECORDS.SOURCE%TYPE) IS

219: AND REGIME_PRIMARY_REGNO = P_REGM_PRMY_REGN
220: AND ( NVL(TRUNC(CREATION_DATE)
221: ,TRUNC(SYSDATE)) ) < ( NVL(P_FROM_DATE
222: ,TRUNC(SYSDATE)) );
223: CURSOR CUR_MANUAL_IN(CP_SOURCE IN JAI_RGM_TRX_RECORDS.SOURCE%TYPE) IS
224: SELECT
225: SUM(CREDIT_AMOUNT)
226: FROM
227: JAI_RGM_TRX_RECORDS

Line 227: JAI_RGM_TRX_RECORDS

223: CURSOR CUR_MANUAL_IN(CP_SOURCE IN JAI_RGM_TRX_RECORDS.SOURCE%TYPE) IS
224: SELECT
225: SUM(CREDIT_AMOUNT)
226: FROM
227: JAI_RGM_TRX_RECORDS
228: WHERE SOURCE = CP_SOURCE
229: AND REGIME_CODE = LV_SERVICE_REGIME
230: AND TAX_TYPE IN ( LV_TAX_TYPE_SERVICE , LV_TAX_TYPE_SERVICE_EDU_CESS , LV_TAX_TYPE_SH_SER_EDU_CESS )
231: AND SOURCE_TRX_TYPE IN ( LV_ADJUST_RECOVERY , LV_RECOVERY )

Line 260: JAI_RGM_TRX_RECORDS

256: SELECT
257: NVL(SUM(DEBIT_AMOUNT)
258: ,0)
259: FROM
260: JAI_RGM_TRX_RECORDS
261: WHERE SOURCE = LV_SERVICE_SRC_DISTRIBUTE_OUT
262: AND REGIME_CODE = LV_SERVICE_REGIME
263: AND TAX_TYPE IN ( LV_TAX_TYPE_SERVICE , LV_TAX_TYPE_SERVICE_EDU_CESS , LV_TAX_TYPE_SH_SER_EDU_CESS )
264: AND REGIME_PRIMARY_REGNO = P_REGM_PRMY_REGN

Line 268: CURSOR CUR_MANUAL_DEBIT(CP_SOURCE IN JAI_RGM_TRX_RECORDS.SOURCE%TYPE) IS

264: AND REGIME_PRIMARY_REGNO = P_REGM_PRMY_REGN
265: AND ( NVL(TRUNC(CREATION_DATE)
266: ,TRUNC(SYSDATE)) ) < ( NVL(P_FROM_DATE
267: ,TRUNC(SYSDATE)) );
268: CURSOR CUR_MANUAL_DEBIT(CP_SOURCE IN JAI_RGM_TRX_RECORDS.SOURCE%TYPE) IS
269: SELECT
270: NVL(SUM(DEBIT_AMOUNT)
271: ,0)
272: FROM

Line 273: JAI_RGM_TRX_RECORDS

269: SELECT
270: NVL(SUM(DEBIT_AMOUNT)
271: ,0)
272: FROM
273: JAI_RGM_TRX_RECORDS
274: WHERE SOURCE = CP_SOURCE
275: AND REGIME_CODE = LV_SERVICE_REGIME
276: AND TAX_TYPE IN ( LV_TAX_TYPE_SERVICE , LV_TAX_TYPE_SH_SER_EDU_CESS , LV_TAX_TYPE_SERVICE_EDU_CESS )
277: AND SOURCE_TRX_TYPE IN ( LV_LIABILITY , LV_ADJUST_LIABILITY )

Line 282: CURSOR CUR_PAYMENT(CP_SOURCE IN JAI_RGM_TRX_RECORDS.SOURCE%TYPE,CP_SOURCE_TRX_TYPE IN JAI_RGM_TRX_RECORDS.SOURCE_TRX_TYPE%TYPE) IS

278: AND REGIME_PRIMARY_REGNO = P_REGM_PRMY_REGN
279: AND ( NVL(TRUNC(CREATION_DATE)
280: ,TRUNC(SYSDATE)) ) < ( NVL(P_FROM_DATE
281: ,TRUNC(SYSDATE)) );
282: CURSOR CUR_PAYMENT(CP_SOURCE IN JAI_RGM_TRX_RECORDS.SOURCE%TYPE,CP_SOURCE_TRX_TYPE IN JAI_RGM_TRX_RECORDS.SOURCE_TRX_TYPE%TYPE) IS
283: SELECT
284: NVL(SUM(DEBIT_AMOUNT)
285: ,0)
286: FROM

Line 287: JAI_RGM_TRX_RECORDS

283: SELECT
284: NVL(SUM(DEBIT_AMOUNT)
285: ,0)
286: FROM
287: JAI_RGM_TRX_RECORDS
288: WHERE SOURCE = CP_SOURCE
289: AND REGIME_CODE = LV_SERVICE_REGIME
290: AND TAX_TYPE IN ( LV_TAX_TYPE_SERVICE , LV_TAX_TYPE_SERVICE_EDU_CESS , LV_TAX_TYPE_SH_SER_EDU_CESS )
291: AND SOURCE_TRX_TYPE = CP_SOURCE_TRX_TYPE