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_REFS

Line 83: CURSOR CUR_AR_UTIL_CREDIT(CP_SOURCE IN JAI_RGM_TRX_REFS.SOURCE%TYPE) IS

79: ,0));
80: END CF_CREDIT_TAKENFORMULA;
81:
82: FUNCTION CF_CREDIT_UTILIZEDFORMULA RETURN NUMBER IS
83: CURSOR CUR_AR_UTIL_CREDIT(CP_SOURCE IN JAI_RGM_TRX_REFS.SOURCE%TYPE) IS
84: SELECT
85: SUM(RECOVERED_AMOUNT)
86: FROM
87: JAI_RGM_TRX_REFS

Line 87: JAI_RGM_TRX_REFS

83: CURSOR CUR_AR_UTIL_CREDIT(CP_SOURCE IN JAI_RGM_TRX_REFS.SOURCE%TYPE) IS
84: SELECT
85: SUM(RECOVERED_AMOUNT)
86: FROM
87: JAI_RGM_TRX_REFS
88: WHERE SOURCE = CP_SOURCE
89: AND TAX_TYPE in ( LV_TAX_TYPE_SERVICE , LV_TAX_TYPE_SERVICE_EDU_CESS , LV_TAX_TYPE_SH_SER_EDU_CESS )
90: AND ORGANIZATION_ID IN (
91: SELECT

Line 121: CURSOR CUR_MANUAL_DEBIT(CP_SOURCE IN JAI_RGM_TRX_REFS.SOURCE%TYPE) IS

117: ,SYSDATE) ) BETWEEN ( NVL(P_FROM_DATE
118: ,SYSDATE) )
119: AND ( NVL(P_TO_DATE
120: ,SYSDATE) );
121: CURSOR CUR_MANUAL_DEBIT(CP_SOURCE IN JAI_RGM_TRX_REFS.SOURCE%TYPE) IS
122: SELECT
123: NVL(SUM(DEBIT_AMOUNT)
124: ,0)
125: FROM

Line 192: CURSOR CUR_INVOICE_OPEN_BAL(CP_SOURCE IN JAI_RGM_TRX_REFS.SOURCE%TYPE) IS

188: ,0));
189: END CF_CLOSING_BALFORMULA;
190:
191: FUNCTION CF_OPENING_BALFORMULA RETURN NUMBER IS
192: CURSOR CUR_INVOICE_OPEN_BAL(CP_SOURCE IN JAI_RGM_TRX_REFS.SOURCE%TYPE) IS
193: SELECT
194: SUM(RECOVERED_AMOUNT)
195: FROM
196: JAI_RGM_TRX_REFS

Line 196: JAI_RGM_TRX_REFS

192: CURSOR CUR_INVOICE_OPEN_BAL(CP_SOURCE IN JAI_RGM_TRX_REFS.SOURCE%TYPE) IS
193: SELECT
194: SUM(RECOVERED_AMOUNT)
195: FROM
196: JAI_RGM_TRX_REFS
197: WHERE SOURCE = CP_SOURCE
198: AND TAX_TYPE in ( LV_TAX_TYPE_SERVICE , LV_TAX_TYPE_SERVICE_EDU_CESS , LV_TAX_TYPE_SH_SER_EDU_CESS )
199: AND TRUNC(CREATION_DATE) < P_FROM_DATE
200: AND ORGANIZATION_ID in (

Line 236: CURSOR CUR_AR_UTIL_CREDIT(CP_SOURCE IN JAI_RGM_TRX_REFS.SOURCE%TYPE) IS

232: AND REGIME_PRIMARY_REGNO = P_REGM_PRMY_REGN
233: AND ( NVL(TRUNC(CREATION_DATE)
234: ,TRUNC(SYSDATE)) ) < ( NVL(P_FROM_DATE
235: ,TRUNC(SYSDATE)) );
236: CURSOR CUR_AR_UTIL_CREDIT(CP_SOURCE IN JAI_RGM_TRX_REFS.SOURCE%TYPE) IS
237: SELECT
238: SUM(RECOVERED_AMOUNT)
239: FROM
240: JAI_RGM_TRX_REFS

Line 240: JAI_RGM_TRX_REFS

236: CURSOR CUR_AR_UTIL_CREDIT(CP_SOURCE IN JAI_RGM_TRX_REFS.SOURCE%TYPE) IS
237: SELECT
238: SUM(RECOVERED_AMOUNT)
239: FROM
240: JAI_RGM_TRX_REFS
241: WHERE SOURCE = CP_SOURCE
242: AND TAX_TYPE in ( LV_TAX_TYPE_SERVICE , LV_TAX_TYPE_SERVICE_EDU_CESS , LV_TAX_TYPE_SH_SER_EDU_CESS )
243: AND TRUNC(CREATION_DATE) < P_FROM_DATE
244: AND ORGANIZATION_ID IN (