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_JAINER1_XMLP_PKG dependencies on JAI_CMN_RG_23AC_II_TRXS

Line 172: LN_CR_BASIC_ED JAI_CMN_RG_23AC_II_TRXS.CR_BASIC_ED%TYPE;

168: RETURN NULL;
169: END CF_OTHER_ACC_CURRENTFORMULA;
170:
171: FUNCTION CF_CENVAT_ACC_CREDITFORMULA RETURN NUMBER IS
172: LN_CR_BASIC_ED JAI_CMN_RG_23AC_II_TRXS.CR_BASIC_ED%TYPE;
173: BEGIN
174: SELECT
175: SUM(DECODE(UPPER(A.PAYMENT_REGISTER)
176: ,'RG23A'

Line 211: LN_CR_OTHER_ED JAI_CMN_RG_23AC_II_TRXS.CR_OTHER_ED%TYPE;

207: RETURN NULL;
208: END CF_CENVAT_ACC_CREDITFORMULA;
209:
210: FUNCTION CF_OTHER_ACC_CREDITFORMULA RETURN NUMBER IS
211: LN_CR_OTHER_ED JAI_CMN_RG_23AC_II_TRXS.CR_OTHER_ED%TYPE;
212: CURSOR CUR_GET_AMOUNT IS
213: SELECT
214: SUM(NVL(DEBIT
215: ,0))

Line 224: JAI_CMN_RG_23AC_II_TRXS

220: AND SOURCE_REGISTER_ID in (
221: SELECT
222: REGISTER_ID
223: FROM
224: JAI_CMN_RG_23AC_II_TRXS
225: WHERE LOCATION_ID = P_LOCATION_ID
226: AND ORGANIZATION_ID = P_ORGANIZATION_ID
227: AND TRUNC(CREATION_DATE) >= P_START_DATE
228: AND TRUNC(CREATION_DATE) <= TRUNC(NVL(P_END_DATE

Line 263: LN_OPENING_BALANCE JAI_CMN_RG_23AC_II_TRXS.OPENING_BALANCE%TYPE;

259: ,0);
260: END CF_OTHER_TOTALFORMULA;
261:
262: FUNCTION CF_OPENING_BALANCEFORMULA RETURN NUMBER IS
263: LN_OPENING_BALANCE JAI_CMN_RG_23AC_II_TRXS.OPENING_BALANCE%TYPE;
264: BEGIN
265: SELECT
266: SUM(NVL(CR_BASIC_ED
267: ,0) + NVL(CR_ADDITIONAL_ED

Line 275: JAI_CMN_RG_23AC_II_TRXS

271: ,0) - NVL(DR_OTHER_ED
272: ,0))
273: INTO LN_OPENING_BALANCE
274: FROM
275: JAI_CMN_RG_23AC_II_TRXS
276: WHERE LOCATION_ID = P_LOCATION_ID
277: AND ORGANIZATION_ID = P_ORGANIZATION_ID
278: AND CREATION_DATE < P_START_DATE;
279: RETURN ROUND(NVL(LN_OPENING_BALANCE

Line 317: JAI_CMN_RG_23AC_II_TRXS RG23

313: NVL(SUM(CREDIT)
314: ,0)
315: FROM
316: JAI_CMN_RG_OTHERS JRO,
317: JAI_CMN_RG_23AC_II_TRXS RG23
318: WHERE JRO.SOURCE_REGISTER_ID = RG23.REGISTER_ID
319: AND RG23.LOCATION_ID = P_LOCATION_ID
320: AND RG23.ORGANIZATION_ID = P_ORGANIZATION_ID
321: AND TRUNC(RG23.CREATION_DATE) >= P_START_DATE

Line 349: JAI_CMN_RG_23AC_II_TRXS RG23

345: NVL(SUM(CREDIT)
346: ,0)
347: FROM
348: JAI_CMN_RG_OTHERS JRO,
349: JAI_CMN_RG_23AC_II_TRXS RG23
350: WHERE JRO.SOURCE_REGISTER_ID = RG23.REGISTER_ID
351: AND RG23.LOCATION_ID = P_LOCATION_ID
352: AND RG23.ORGANIZATION_ID = P_ORGANIZATION_ID
353: AND TRUNC(RG23.CREATION_DATE) >= P_START_DATE

Line 803: LV_REGISTER_ID JAI_CMN_RG_23AC_II_TRXS.REGISTER_ID%TYPE;

799: RETURN NULL;
800: END CF_CESS_TAX_DUTY_SERVICESFORMU;
801:
802: FUNCTION CF_CESS_OPENING_BLNCFORMULA RETURN NUMBER IS
803: LV_REGISTER_ID JAI_CMN_RG_23AC_II_TRXS.REGISTER_ID%TYPE;
804: CURSOR CUR_OPENING_BAL IS
805: SELECT
806: SUM(NVL(CREDIT
807: ,0) - NVL(DEBIT

Line 816: JAI_CMN_RG_23AC_II_TRXS

812: AND SOURCE_REGISTER_ID in (
813: SELECT
814: REGISTER_ID
815: FROM
816: JAI_CMN_RG_23AC_II_TRXS
817: WHERE LOCATION_ID = P_LOCATION_ID
818: AND ORGANIZATION_ID = P_ORGANIZATION_ID
819: AND TRUNC(CREATION_DATE) < P_START_DATE )
820: AND TAX_TYPE in ( TAX_TYPE_CVD_EDU_CESS , TAX_TYPE_EXC_EDU_CESS );

Line 1689: JAI_CMN_RG_23AC_II_TRXS RG23

1685: ,0)
1686: INTO LN_EDU_CESS_EXCISE
1687: FROM
1688: JAI_CMN_RG_OTHERS JRO,
1689: JAI_CMN_RG_23AC_II_TRXS RG23
1690: WHERE JRO.SOURCE_REGISTER_ID = RG23.REGISTER_ID
1691: AND RG23.LOCATION_ID = P_LOCATION_ID
1692: AND RG23.ORGANIZATION_ID = P_ORGANIZATION_ID
1693: AND TRUNC(RG23.CREATION_DATE) >= P_START_DATE

Line 1742: JAI_CMN_RG_23AC_II_TRXS JIRP,

1738: ,0) + NVL(CR_OTHER_ED
1739: ,0)
1740: ,0)) CREDIT_AVAILED_ON_INPUTS_VEND
1741: FROM
1742: JAI_CMN_RG_23AC_II_TRXS JIRP,
1743: JAI_CMN_VENDOR_SITES JIPV
1744: WHERE LOCATION_ID = P_LOCATION_ID
1745: AND ORGANIZATION_ID = P_ORGANIZATION_ID
1746: AND JIRP.VENDOR_ID = JIPV.VENDOR_ID

Line 1781: JAI_CMN_RG_23AC_II_TRXS JIRP,

1777: ,0) + NVL(CR_OTHER_ED
1778: ,0)
1779: ,0)) CREDIT_AVAILED_ON_INPUTS_CUST
1780: FROM
1781: JAI_CMN_RG_23AC_II_TRXS JIRP,
1782: JAI_CMN_CUS_ADDRESSES JICA,
1783: HZ_CUST_ACCT_SITES_ALL HZCAS,
1784: HZ_CUST_SITE_USES_ALL HZCSU
1785: WHERE HZCAS.CUST_ACCT_SITE_ID = HZCSU.CUST_ACCT_SITE_ID

Line 1822: JAI_CMN_RG_23AC_II_TRXS JIRP,

1818: ,0) + NVL(CR_OTHER_ED
1819: ,0)
1820: ,0)) CREDIT_AVAILED_ON_INPUTS
1821: FROM
1822: JAI_CMN_RG_23AC_II_TRXS JIRP,
1823: JAI_CMN_INVENTORY_ORGS JIHO
1824: WHERE JIRP.LOCATION_ID = P_LOCATION_ID
1825: AND JIRP.ORGANIZATION_ID = P_ORGANIZATION_ID
1826: AND ABS(JIRP.VENDOR_ID) = JIHO.ORGANIZATION_ID

Line 1865: JAI_CMN_RG_23AC_II_TRXS JIRP,

1861: ,0))
1862: ,0)
1863: ,0) CREDIT_ON_IMPORT_INPUTS
1864: FROM
1865: JAI_CMN_RG_23AC_II_TRXS JIRP,
1866: JAI_INV_ITM_SETUPS JMSI
1867: WHERE JIRP.LOCATION_ID = P_LOCATION_ID
1868: AND JIRP.ORGANIZATION_ID = P_ORGANIZATION_ID
1869: AND JIRP.ORGANIZATION_ID = JMSI.ORGANIZATION_ID

Line 1930: JAI_CMN_RG_23AC_II_TRXS JIRP,

1926: ,0) + NVL(CR_OTHER_ED
1927: ,0)
1928: ,0)) CREDIT_AVAILED_ON_INPUTS
1929: FROM
1930: JAI_CMN_RG_23AC_II_TRXS JIRP,
1931: JAI_CMN_VENDOR_SITES JIPV
1932: WHERE LOCATION_ID = P_LOCATION_ID
1933: AND ORGANIZATION_ID = P_ORGANIZATION_ID
1934: AND JIRP.VENDOR_ID = JIPV.VENDOR_ID

Line 1968: JAI_CMN_RG_23AC_II_TRXS JIRP,

1964: ,0) + NVL(CR_OTHER_ED
1965: ,0)
1966: ,0)) CREDIT_AVAILED_ON_INPUTS
1967: FROM
1968: JAI_CMN_RG_23AC_II_TRXS JIRP,
1969: JAI_CMN_INVENTORY_ORGS JIHO
1970: WHERE JIRP.LOCATION_ID = P_LOCATION_ID
1971: AND JIRP.ORGANIZATION_ID = P_ORGANIZATION_ID
1972: AND ABS(JIRP.VENDOR_ID) = JIHO.ORGANIZATION_ID

Line 2025: JAI_CMN_RG_23AC_II_TRXS RG23,

2021: NVL(SUM(CREDIT)
2022: ,0)
2023: FROM
2024: JAI_CMN_RG_OTHERS JRO,
2025: JAI_CMN_RG_23AC_II_TRXS RG23,
2026: JAI_CMN_VENDOR_SITES JIPV
2027: WHERE JRO.SOURCE_REGISTER_ID = RG23.REGISTER_ID
2028: AND RG23.VENDOR_ID = JIPV.VENDOR_ID
2029: AND RG23.VENDOR_SITE_ID = JIPV.VENDOR_SITE_ID

Line 2046: JAI_CMN_RG_23AC_II_TRXS RG23,

2042: NVL(SUM(CREDIT)
2043: ,0)
2044: FROM
2045: JAI_CMN_RG_OTHERS JRO,
2046: JAI_CMN_RG_23AC_II_TRXS RG23,
2047: JAI_CMN_CUS_ADDRESSES JICA,
2048: HZ_CUST_ACCT_SITES_ALL HZCAS,
2049: HZ_CUST_SITE_USES_ALL HZCSU
2050: WHERE HZCAS.CUST_ACCT_SITE_ID = HZCSU.CUST_ACCT_SITE_ID

Line 2069: JAI_CMN_RG_23AC_II_TRXS RG23,

2065: NVL(SUM(CREDIT)
2066: ,0)
2067: FROM
2068: JAI_CMN_RG_OTHERS JRO,
2069: JAI_CMN_RG_23AC_II_TRXS RG23,
2070: JAI_CMN_INVENTORY_ORGS JIHO
2071: WHERE JRO.SOURCE_REGISTER_ID = RG23.REGISTER_ID
2072: AND ABS(RG23.VENDOR_ID) = JIHO.ORGANIZATION_ID
2073: AND ABS(RG23.VENDOR_SITE_ID) = JIHO.LOCATION_ID

Line 2122: JAI_CMN_RG_23AC_II_TRXS RG23,

2118: NVL(SUM(CREDIT)
2119: ,0)
2120: FROM
2121: JAI_CMN_RG_OTHERS JRO,
2122: JAI_CMN_RG_23AC_II_TRXS RG23,
2123: JAI_CMN_VENDOR_SITES JIPV
2124: WHERE JRO.SOURCE_REGISTER_ID = RG23.REGISTER_ID
2125: AND RG23.VENDOR_ID = JIPV.vendor_id (+)
2126: AND RG23.VENDOR_SITE_ID = JIPV.vendor_site_id (+)

Line 2142: JAI_CMN_RG_23AC_II_TRXS RG23,

2138: NVL(SUM(CREDIT)
2139: ,0)
2140: FROM
2141: JAI_CMN_RG_OTHERS JRO,
2142: JAI_CMN_RG_23AC_II_TRXS RG23,
2143: JAI_CMN_INVENTORY_ORGS JIHO
2144: WHERE JRO.SOURCE_REGISTER_ID = RG23.REGISTER_ID
2145: AND ABS(RG23.VENDOR_ID) = JIHO.ORGANIZATION_ID
2146: AND ABS(RG23.VENDOR_SITE_ID) = JIHO.LOCATION_ID

Line 2229: JAI_CMN_RG_23AC_II_TRXS JIRP

2225: PVS.ADDRESS_LINE3,
2226: PVS.VENDOR_SITE_ID
2227: FROM
2228: PO_VENDOR_SITES_ALL PVS,
2229: JAI_CMN_RG_23AC_II_TRXS JIRP
2230: WHERE JIRP.VENDOR_ID = PVS.VENDOR_ID
2231: AND JIRP.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID
2232: AND JIRP.VENDOR_ID || JIRP.VENDOR_SITE_ID NOT IN (
2233: SELECT

Line 2291: JAI_CMN_RG_23AC_II_TRXS JRG23_II,

2287: ,0) + NVL(JRG23_II.DR_ADDITIONAL_ED
2288: ,0) + NVL(JRG23_II.DR_OTHER_ED
2289: ,0))
2290: FROM
2291: JAI_CMN_RG_23AC_II_TRXS JRG23_II,
2292: JAI_CMN_RG_23AC_I_TRXS JRG23_I
2293: WHERE JRG23_II.ORGANIZATION_ID = P_ORGANIZATION_ID
2294: AND JRG23_II.LOCATION_ID = P_LOCATION_ID
2295: AND TRUNC(JRG23_II.CREATION_DATE) >= P_START_DATE

Line 2309: JAI_CMN_RG_23AC_II_TRXS JRG23_II,

2305: ,0) + NVL(JRG23_II.DR_ADDITIONAL_ED
2306: ,0) + NVL(JRG23_II.DR_OTHER_ED
2307: ,0))
2308: FROM
2309: JAI_CMN_RG_23AC_II_TRXS JRG23_II,
2310: JAI_CMN_RG_23AC_I_TRXS JRG23_I,
2311: JAI_INV_ITM_SETUPS JMSI
2312: WHERE JRG23_II.ORGANIZATION_ID = JRG23_I.ORGANIZATION_ID
2313: AND JRG23_II.LOCATION_ID = JRG23_I.LOCATION_ID

Line 2368: JAI_CMN_RG_23AC_II_TRXS JRG23_II,

2364: AND SOURCE_REGISTER_ID in (
2365: SELECT
2366: JRG23_II.REGISTER_ID
2367: FROM
2368: JAI_CMN_RG_23AC_II_TRXS JRG23_II,
2369: JAI_CMN_RG_23AC_I_TRXS JRG23_I
2370: WHERE JRG23_II.ORGANIZATION_ID = P_ORGANIZATION_ID
2371: AND JRG23_II.LOCATION_ID = P_LOCATION_ID
2372: AND TRUNC(JRG23_II.CREATION_DATE) >= P_START_DATE

Line 2391: JAI_CMN_RG_23AC_II_TRXS JRG23_II,

2387: AND SOURCE_REGISTER_ID in (
2388: SELECT
2389: JRG23_II.REGISTER_ID
2390: FROM
2391: JAI_CMN_RG_23AC_II_TRXS JRG23_II,
2392: JAI_CMN_RG_23AC_I_TRXS JRG23_I,
2393: JAI_INV_ITM_SETUPS JMSI
2394: WHERE JRG23_II.ORGANIZATION_ID = JRG23_I.ORGANIZATION_ID
2395: AND JRG23_II.LOCATION_ID = JRG23_I.LOCATION_ID

Line 2446: JAI_CMN_RG_23AC_II_TRXS JIRP,

2442: ,0)
2443: ,0))
2444: ,0) CREDIT_AVAILED_ON_CAP_GOODS
2445: FROM
2446: JAI_CMN_RG_23AC_II_TRXS JIRP,
2447: JAI_INV_ITM_SETUPS JMSI
2448: WHERE JIRP.LOCATION_ID = P_LOCATION_ID
2449: AND JIRP.ORGANIZATION_ID = P_ORGANIZATION_ID
2450: AND JIRP.ORGANIZATION_ID = JMSI.ORGANIZATION_ID

Line 2550: JAI_CMN_RG_23AC_II_TRXS

2546: ROUND(SUM(NVL(DR_ADDITIONAL_ED
2547: ,0))
2548: ,0) AED_CREDIT_UTILIZED
2549: FROM
2550: JAI_CMN_RG_23AC_II_TRXS
2551: WHERE LOCATION_ID = P_LOCATION_ID
2552: AND ORGANIZATION_ID = P_ORGANIZATION_ID
2553: AND TRUNC(CREATION_DATE) >= P_START_DATE
2554: AND TRUNC(CREATION_DATE) <= TRUNC(NVL(P_END_DATE

Line 2618: LV_REGISTER_ID JAI_CMN_RG_23AC_II_TRXS.REGISTER_ID%TYPE;

2614: RETURN LV_UQC;
2615: END CF_EXCISE_UOMFORMULA;
2616:
2617: FUNCTION CF_SH_CESS_OPENING_BLNCFORMULA RETURN NUMBER IS
2618: LV_REGISTER_ID JAI_CMN_RG_23AC_II_TRXS.REGISTER_ID%TYPE;
2619: CURSOR CUR_OPENING_BAL IS
2620: SELECT
2621: SUM(NVL(CREDIT
2622: ,0) - NVL(DEBIT

Line 2631: JAI_CMN_RG_23AC_II_TRXS

2627: AND SOURCE_REGISTER_ID in (
2628: SELECT
2629: REGISTER_ID
2630: FROM
2631: JAI_CMN_RG_23AC_II_TRXS
2632: WHERE LOCATION_ID = P_LOCATION_ID
2633: AND ORGANIZATION_ID = P_ORGANIZATION_ID
2634: AND TRUNC(CREATION_DATE) < P_START_DATE )
2635: AND TAX_TYPE in ( TAX_TYPE_SH_CVD_EDU_CESS , TAX_TYPE_SH_EXC_EDU_CESS );

Line 2653: JAI_CMN_RG_23AC_II_TRXS RG23,

2649: NVL(SUM(CREDIT)
2650: ,0)
2651: FROM
2652: JAI_CMN_RG_OTHERS JRO,
2653: JAI_CMN_RG_23AC_II_TRXS RG23,
2654: JAI_CMN_VENDOR_SITES JIPV
2655: WHERE JRO.SOURCE_REGISTER_ID = RG23.REGISTER_ID
2656: AND RG23.VENDOR_ID = JIPV.VENDOR_ID
2657: AND RG23.VENDOR_SITE_ID = JIPV.VENDOR_SITE_ID

Line 2674: JAI_CMN_RG_23AC_II_TRXS RG23,

2670: NVL(SUM(CREDIT)
2671: ,0)
2672: FROM
2673: JAI_CMN_RG_OTHERS JRO,
2674: JAI_CMN_RG_23AC_II_TRXS RG23,
2675: JAI_CMN_CUS_ADDRESSES JICA,
2676: HZ_CUST_ACCT_SITES_ALL HZCAS,
2677: HZ_CUST_SITE_USES_ALL HZCSU
2678: WHERE HZCAS.CUST_ACCT_SITE_ID = HZCSU.CUST_ACCT_SITE_ID

Line 2697: JAI_CMN_RG_23AC_II_TRXS RG23,

2693: NVL(SUM(CREDIT)
2694: ,0)
2695: FROM
2696: JAI_CMN_RG_OTHERS JRO,
2697: JAI_CMN_RG_23AC_II_TRXS RG23,
2698: JAI_CMN_INVENTORY_ORGS JIHO
2699: WHERE JRO.SOURCE_REGISTER_ID = RG23.REGISTER_ID
2700: AND ABS(RG23.VENDOR_ID) = JIHO.ORGANIZATION_ID
2701: AND ABS(RG23.VENDOR_SITE_ID) = JIHO.LOCATION_ID

Line 2750: JAI_CMN_RG_23AC_II_TRXS RG23,

2746: NVL(SUM(CREDIT)
2747: ,0)
2748: FROM
2749: JAI_CMN_RG_OTHERS JRO,
2750: JAI_CMN_RG_23AC_II_TRXS RG23,
2751: JAI_CMN_VENDOR_SITES JIPV
2752: WHERE JRO.SOURCE_REGISTER_ID = RG23.REGISTER_ID
2753: AND RG23.VENDOR_ID = JIPV.vendor_id (+)
2754: AND RG23.VENDOR_SITE_ID = JIPV.vendor_site_id (+)

Line 2770: JAI_CMN_RG_23AC_II_TRXS RG23,

2766: NVL(SUM(CREDIT)
2767: ,0)
2768: FROM
2769: JAI_CMN_RG_OTHERS JRO,
2770: JAI_CMN_RG_23AC_II_TRXS RG23,
2771: JAI_CMN_INVENTORY_ORGS JIHO
2772: WHERE JRO.SOURCE_REGISTER_ID = RG23.REGISTER_ID
2773: AND ABS(RG23.VENDOR_ID) = JIHO.ORGANIZATION_ID
2774: AND ABS(RG23.VENDOR_SITE_ID) = JIHO.LOCATION_ID

Line 2818: JAI_CMN_RG_23AC_II_TRXS RG23

2814: NVL(SUM(CREDIT)
2815: ,0)
2816: FROM
2817: JAI_CMN_RG_OTHERS JRO,
2818: JAI_CMN_RG_23AC_II_TRXS RG23
2819: WHERE JRO.SOURCE_REGISTER_ID = RG23.REGISTER_ID
2820: AND RG23.LOCATION_ID = P_LOCATION_ID
2821: AND RG23.ORGANIZATION_ID = P_ORGANIZATION_ID
2822: AND TRUNC(RG23.CREATION_DATE) >= P_START_DATE

Line 2859: JAI_CMN_RG_23AC_II_TRXS RG23

2855: NVL(SUM(CREDIT)
2856: ,0)
2857: FROM
2858: JAI_CMN_RG_OTHERS JRO,
2859: JAI_CMN_RG_23AC_II_TRXS RG23
2860: WHERE JRO.SOURCE_REGISTER_ID = RG23.REGISTER_ID
2861: AND RG23.LOCATION_ID = P_LOCATION_ID
2862: AND RG23.ORGANIZATION_ID = P_ORGANIZATION_ID
2863: AND TRUNC(RG23.CREATION_DATE) >= P_START_DATE

Line 2891: JAI_CMN_RG_23AC_II_TRXS RG23

2887: NVL(SUM(DEBIT)
2888: ,0)
2889: FROM
2890: JAI_CMN_RG_OTHERS JRO,
2891: JAI_CMN_RG_23AC_II_TRXS RG23
2892: WHERE JRO.SOURCE_REGISTER_ID = RG23.REGISTER_ID
2893: AND RG23.LOCATION_ID = P_LOCATION_ID
2894: AND RG23.ORGANIZATION_ID = P_ORGANIZATION_ID
2895: AND TRUNC(RG23.CREATION_DATE) >= P_START_DATE

Line 3099: JAI_CMN_RG_23AC_II_TRXS JRG23_II,

3095: AND SOURCE_REGISTER_ID in (
3096: SELECT
3097: JRG23_II.REGISTER_ID
3098: FROM
3099: JAI_CMN_RG_23AC_II_TRXS JRG23_II,
3100: JAI_CMN_RG_23AC_I_TRXS JRG23_I
3101: WHERE JRG23_II.ORGANIZATION_ID = P_ORGANIZATION_ID
3102: AND JRG23_II.LOCATION_ID = P_LOCATION_ID
3103: AND TRUNC(JRG23_II.CREATION_DATE) >= P_START_DATE

Line 3122: JAI_CMN_RG_23AC_II_TRXS JRG23_II,

3118: AND SOURCE_REGISTER_ID in (
3119: SELECT
3120: JRG23_II.REGISTER_ID
3121: FROM
3122: JAI_CMN_RG_23AC_II_TRXS JRG23_II,
3123: JAI_CMN_RG_23AC_I_TRXS JRG23_I,
3124: JAI_INV_ITM_SETUPS JMSI
3125: WHERE JRG23_II.ORGANIZATION_ID = JRG23_I.ORGANIZATION_ID
3126: AND JRG23_II.LOCATION_ID = JRG23_I.LOCATION_ID

Line 3305: LN_CR_OTHER_ED JAI_CMN_RG_23AC_II_TRXS.CR_OTHER_ED%TYPE;

3301: ,0);
3302: END CF_TOT_CR_AVAILED_SH_SCFORMULA;
3303:
3304: FUNCTION CF_OTHER_SH_ACC_CREDITFORMULA RETURN NUMBER IS
3305: LN_CR_OTHER_ED JAI_CMN_RG_23AC_II_TRXS.CR_OTHER_ED%TYPE;
3306: CURSOR CUR_GET_AMOUNT IS
3307: SELECT
3308: SUM(NVL(DEBIT
3309: ,0))

Line 3318: JAI_CMN_RG_23AC_II_TRXS

3314: AND SOURCE_REGISTER_ID in (
3315: SELECT
3316: REGISTER_ID
3317: FROM
3318: JAI_CMN_RG_23AC_II_TRXS
3319: WHERE LOCATION_ID = P_LOCATION_ID
3320: AND ORGANIZATION_ID = P_ORGANIZATION_ID
3321: AND TRUNC(CREATION_DATE) >= P_START_DATE
3322: AND TRUNC(CREATION_DATE) <= TRUNC(NVL(P_END_DATE