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_JAINST3_XMLP_PKG dependencies on JAI_RGM_TRX_RECORDS

Line 47: JAI_RGM_TRX_RECORDS TRXRECS

43: ,'Service'
44: ,TRXRECS.CREDIT_AMOUNT
45: ,0)) SERVICE_AMOUNT
46: FROM
47: JAI_RGM_TRX_RECORDS TRXRECS
48: WHERE TRXRECS.SOURCE in ( 'AP' , 'MANUAL' )
49: AND TRXRECS.SOURCE_TRX_TYPE = 'PAYMENT'
50: AND TRXRECS.REGIME_CODE = 'SERVICE'
51: AND TRUNC(TRXRECS.TRANSACTION_DATE) between PRM_FROMDT

Line 60: LN_SERVICE_AMOUNT JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;

56: AND TO_CHAR(TRXRECS.TRANSACTION_DATE
57: ,'MON-YYYY') = LV_MON_YEAR
58: AND SERVICE_TYPE_CODE = NVL(PRM_SERVICE_TYPE
59: ,SERVICE_TYPE_CODE);
60: LN_SERVICE_AMOUNT JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
61: BEGIN
62: LV_MON_YEAR := MONTH || '-' || YEAR;
63: OPEN C_SERVICE;
64: FETCH C_SERVICE

Line 115: JAI_RGM_TRX_RECORDS TRXRECS

111: ,'Service'
112: ,TRXRECS.CREDIT_AMOUNT
113: ,0)) SERVICE_ST_AMOUNT
114: FROM
115: JAI_RGM_TRX_RECORDS TRXRECS
116: WHERE ( TRXRECS.SOURCE in ( 'AP' , 'SERVICE_DISTRIBUTE_IN' )
117: OR TRXRECS.SOURCE in ( 'MANUAL' )
118: AND TRXRECS.SOURCE_TRX_TYPE in ( 'ADJUSTMENT-RECOVERY' , 'RECOVERY' ) )
119: AND TRXRECS.REGIME_CODE = 'SERVICE'

Line 129: LN_SERVICE_ST_AMOUNT JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;

125: AND TO_CHAR(TRXRECS.TRANSACTION_DATE
126: ,'MON-YYYY') = LV_MON_YEAR
127: AND SERVICE_TYPE_CODE = NVL(PRM_SERVICE_TYPE
128: ,SERVICE_TYPE_CODE);
129: LN_SERVICE_ST_AMOUNT JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
130: BEGIN
131: LV_MON_YEAR := MONTH || '-' || YEAR;
132: OPEN C_ST_SERVICE;
133: FETCH C_ST_SERVICE

Line 169: JAI_RGM_TRX_RECORDS

165: CURSOR CUR_DIST_IN IS
166: SELECT
167: SUM(CREDIT_AMOUNT)
168: FROM
169: JAI_RGM_TRX_RECORDS
170: WHERE SOURCE = 'SERVICE_DISTRIBUTE_IN'
171: AND REGIME_CODE = 'SERVICE'
172: AND TAX_TYPE IN ( 'Service' )
173: AND REGIME_PRIMARY_REGNO = PRM_RGM_PRIM_REGNO

Line 184: JAI_RGM_TRX_RECORDS

180: CURSOR CUR_MANUAL_IN IS
181: SELECT
182: SUM(CREDIT_AMOUNT)
183: FROM
184: JAI_RGM_TRX_RECORDS
185: WHERE SOURCE = 'MANUAL'
186: AND REGIME_CODE = 'SERVICE'
187: AND TAX_TYPE IN ( 'Service' )
188: AND SOURCE_TRX_TYPE IN ( 'ADJUSTMENT-RECOVERY' , 'RECOVERY' )

Line 221: JAI_RGM_TRX_RECORDS

217: SELECT
218: NVL(SUM(DEBIT_AMOUNT)
219: ,0)
220: FROM
221: JAI_RGM_TRX_RECORDS
222: WHERE SOURCE = 'SERVICE_DISTRIBUTE_OUT'
223: AND REGIME_CODE = 'SERVICE'
224: AND TAX_TYPE IN ( 'Service' )
225: AND REGIME_PRIMARY_REGNO = PRM_RGM_PRIM_REGNO

Line 237: JAI_RGM_TRX_RECORDS

233: SELECT
234: NVL(SUM(DEBIT_AMOUNT)
235: ,0)
236: FROM
237: JAI_RGM_TRX_RECORDS
238: WHERE SOURCE = 'MANUAL'
239: AND REGIME_CODE = 'SERVICE'
240: AND TAX_TYPE IN ( 'Service' )
241: AND SOURCE_TRX_TYPE IN ( 'ADJUSTMENT-LIABILITY' , 'LIABILITY' )

Line 254: JAI_RGM_TRX_RECORDS

250: SELECT
251: NVL(SUM(DEBIT_AMOUNT)
252: ,0)
253: FROM
254: JAI_RGM_TRX_RECORDS
255: WHERE SOURCE = 'MANUAL'
256: AND REGIME_CODE = 'SERVICE'
257: AND TAX_TYPE IN ( 'Service' )
258: AND SOURCE_TRX_TYPE = 'PAYMENT'

Line 319: JAI_RGM_TRX_RECORDS TRXRECS,

315: CURSOR C_SERV_CREDIT(CPV_ITEM_CLASS IN VARCHAR2) IS
316: SELECT
317: SUM(TRXRECS.CREDIT_AMOUNT) SERVICE_CREDIT
318: FROM
319: JAI_RGM_TRX_RECORDS TRXRECS,
320: JAI_RGM_TRX_REFS TRXREFS,
321: AP_INVOICES_ALL APA,
322: JAI_CMN_VENDOR_SITES JPVS,
323: PO_VENDOR_SITES_ALL PVSA,

Line 353: JAI_RGM_TRX_RECORDS JRTR,

349: CURSOR C_SERV_CREDIT_1(CPV_ITEM_CLASS IN VARCHAR2) IS
350: SELECT
351: SUM(JRTR.CREDIT_AMOUNT) SERVICE_CREDIT
352: FROM
353: JAI_RGM_TRX_RECORDS JRTR,
354: JAI_RGM_MANUAL_TRXS JMT,
355: PO_VENDOR_SITES_ALL PVSA
356: WHERE JRTR.SOURCE = 'MANUAL'
357: AND JRTR.REGIME_CODE = 'SERVICE'

Line 373: LN_SERV_CREDIT_RMIN JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;

369: ,JRTR.SERVICE_TYPE_CODE)
370: AND JRTR.ORGANIZATION_ID = NVL(PRM_ORG_ID
371: ,JRTR.ORGANIZATION_ID)
372: AND JRTR.TAX_TYPE = 'Service';
373: LN_SERV_CREDIT_RMIN JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
374: LN_SERV_CREDIT_RM JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
375: LN_SERV_CREDIT_CGIN JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
376: LN_SERV_CREDIT_FG JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
377: BEGIN

Line 374: LN_SERV_CREDIT_RM JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;

370: AND JRTR.ORGANIZATION_ID = NVL(PRM_ORG_ID
371: ,JRTR.ORGANIZATION_ID)
372: AND JRTR.TAX_TYPE = 'Service';
373: LN_SERV_CREDIT_RMIN JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
374: LN_SERV_CREDIT_RM JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
375: LN_SERV_CREDIT_CGIN JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
376: LN_SERV_CREDIT_FG JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
377: BEGIN
378: LV_DATE := MONTH1 || '-' || YEAR1;

Line 375: LN_SERV_CREDIT_CGIN JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;

371: ,JRTR.ORGANIZATION_ID)
372: AND JRTR.TAX_TYPE = 'Service';
373: LN_SERV_CREDIT_RMIN JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
374: LN_SERV_CREDIT_RM JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
375: LN_SERV_CREDIT_CGIN JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
376: LN_SERV_CREDIT_FG JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
377: BEGIN
378: LV_DATE := MONTH1 || '-' || YEAR1;
379: OPEN C_SERV_CREDIT('RMIN');

Line 376: LN_SERV_CREDIT_FG JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;

372: AND JRTR.TAX_TYPE = 'Service';
373: LN_SERV_CREDIT_RMIN JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
374: LN_SERV_CREDIT_RM JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
375: LN_SERV_CREDIT_CGIN JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
376: LN_SERV_CREDIT_FG JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
377: BEGIN
378: LV_DATE := MONTH1 || '-' || YEAR1;
379: OPEN C_SERV_CREDIT('RMIN');
380: FETCH C_SERV_CREDIT

Line 409: JAI_RGM_TRX_RECORDS JRTR

405: CURSOR C_CREDIT_RECEIVED IS
406: SELECT
407: SUM(JRTR.CREDIT_AMOUNT) SERVICE_CREDIT
408: FROM
409: JAI_RGM_TRX_RECORDS JRTR
410: WHERE JRTR.SOURCE = 'SERVICE_DISTRIBUTE_IN'
411: AND JRTR.REGIME_CODE = 'SERVICE'
412: AND JRTR.REGIME_PRIMARY_REGNO = PRM_RGM_PRIM_REGNO
413: AND TRUNC(JRTR.TRANSACTION_DATE) BETWEEN TRUNC(PRM_FROMDT)

Line 422: LN_SERV_CREDIT JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;

418: ,JRTR.SERVICE_TYPE_CODE)
419: AND JRTR.ORGANIZATION_ID = NVL(PRM_ORG_ID
420: ,JRTR.ORGANIZATION_ID)
421: AND JRTR.TAX_TYPE = 'Service';
422: LN_SERV_CREDIT JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
423: BEGIN
424: LV_DATE := MONTH1 || '-' || YEAR1;
425: OPEN C_CREDIT_RECEIVED;
426: FETCH C_CREDIT_RECEIVED

Line 466: JAI_RGM_TRX_RECORDS TRXRECS

462: SELECT
463: NVL(SUM(DEBIT_AMOUNT)
464: ,0)
465: FROM
466: JAI_RGM_TRX_RECORDS TRXRECS
467: WHERE SOURCE = 'SERVICE_DISTRIBUTE_OUT'
468: AND REGIME_CODE = 'SERVICE'
469: AND TAX_TYPE IN ( 'Service' , 'SERVICE_EDUCATION_CESS' )
470: AND REGIME_PRIMARY_REGNO = PRM_RGM_PRIM_REGNO

Line 487: JAI_RGM_TRX_RECORDS TRXRECS

483: SELECT
484: NVL(SUM(DEBIT_AMOUNT)
485: ,0)
486: FROM
487: JAI_RGM_TRX_RECORDS TRXRECS
488: WHERE SOURCE = 'MANUAL'
489: AND REGIME_CODE = 'SERVICE'
490: AND TAX_TYPE IN ( 'Service' , 'SERVICE_EDUCATION_CESS' )
491: AND SOURCE_TRX_TYPE IN ( 'ADJUSTMENT-LIABILITY' , 'LIABILITY' )

Line 509: JAI_RGM_TRX_RECORDS TRXRECS

505: SELECT
506: NVL(SUM(DEBIT_AMOUNT)
507: ,0)
508: FROM
509: JAI_RGM_TRX_RECORDS TRXRECS
510: WHERE SOURCE = 'MANUAL'
511: AND REGIME_CODE = 'SERVICE'
512: AND TAX_TYPE IN ( 'Service' , 'SERVICE_EDUCATION_CESS' )
513: AND SOURCE_TRX_TYPE = 'PAYMENT'

Line 561: JAI_RGM_TRX_RECORDS TRXRECS,

557: CURSOR C_SERV_CREDIT IS
558: SELECT
559: SUM(TRXRECS.CREDIT_AMOUNT) SERVICE_CREDIT
560: FROM
561: JAI_RGM_TRX_RECORDS TRXRECS,
562: JAI_RGM_TRX_REFS TRXREFS,
563: AP_INVOICES_ALL APA,
564: JAI_CMN_VENDOR_SITES JPVS,
565: PO_VENDOR_SITES_ALL PVSA,

Line 594: JAI_RGM_TRX_RECORDS JRTR,

590: CURSOR C_SERV_CREDIT_1 IS
591: SELECT
592: SUM(JRTR.CREDIT_AMOUNT) SERVICE_CREDIT
593: FROM
594: JAI_RGM_TRX_RECORDS JRTR,
595: JAI_RGM_MANUAL_TRXS JMT,
596: PO_VENDOR_SITES_ALL PVSA
597: WHERE JRTR.SOURCE = 'MANUAL'
598: AND JRTR.REGIME_CODE = 'SERVICE'

Line 617: JAI_RGM_TRX_RECORDS JRTR

613: CURSOR C_TAX_AMOUNT IS
614: SELECT
615: SUM(JRTR.CREDIT_AMOUNT) TAX_AMOUNT
616: FROM
617: JAI_RGM_TRX_RECORDS JRTR
618: WHERE JRTR.SOURCE = 'SERVICE_DISTRIBUTE_IN'
619: AND JRTR.REGIME_CODE = 'SERVICE'
620: AND JRTR.REGIME_PRIMARY_REGNO = PRM_RGM_PRIM_REGNO
621: AND TRUNC(JRTR.TRANSACTION_DATE) BETWEEN TRUNC(PRM_FROMDT)

Line 629: LN_SERV_CREDIT JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;

625: AND JRTR.SERVICE_TYPE_CODE = NVL(PRM_SERVICE_TYPE
626: ,JRTR.SERVICE_TYPE_CODE)
627: AND JRTR.ORGANIZATION_ID = NVL(PRM_ORG_ID
628: ,JRTR.ORGANIZATION_ID);
629: LN_SERV_CREDIT JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
630: LN_SERV_CREDIT1 JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
631: LN_TAX_AMOUNT JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
632: BEGIN
633: LV_DATE := MONTH1 || '-' || YEAR1;

Line 630: LN_SERV_CREDIT1 JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;

626: ,JRTR.SERVICE_TYPE_CODE)
627: AND JRTR.ORGANIZATION_ID = NVL(PRM_ORG_ID
628: ,JRTR.ORGANIZATION_ID);
629: LN_SERV_CREDIT JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
630: LN_SERV_CREDIT1 JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
631: LN_TAX_AMOUNT JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
632: BEGIN
633: LV_DATE := MONTH1 || '-' || YEAR1;
634: OPEN C_SERV_CREDIT;

Line 631: LN_TAX_AMOUNT JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;

627: AND JRTR.ORGANIZATION_ID = NVL(PRM_ORG_ID
628: ,JRTR.ORGANIZATION_ID);
629: LN_SERV_CREDIT JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
630: LN_SERV_CREDIT1 JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
631: LN_TAX_AMOUNT JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
632: BEGIN
633: LV_DATE := MONTH1 || '-' || YEAR1;
634: OPEN C_SERV_CREDIT;
635: FETCH C_SERV_CREDIT

Line 689: JAI_RGM_TRX_RECORDS

685: CURSOR CUR_DIST_IN IS
686: SELECT
687: SUM(CREDIT_AMOUNT)
688: FROM
689: JAI_RGM_TRX_RECORDS
690: WHERE SOURCE = 'SERVICE_DISTRIBUTE_IN'
691: AND REGIME_CODE = 'SERVICE'
692: AND TAX_TYPE IN ( 'SERVICE_EDUCATION_CESS' )
693: AND REGIME_PRIMARY_REGNO = PRM_RGM_PRIM_REGNO

Line 704: JAI_RGM_TRX_RECORDS

700: CURSOR CUR_MANUAL_IN IS
701: SELECT
702: SUM(CREDIT_AMOUNT)
703: FROM
704: JAI_RGM_TRX_RECORDS
705: WHERE SOURCE = 'MANUAL'
706: AND REGIME_CODE = 'SERVICE'
707: AND TAX_TYPE IN ( 'SERVICE_EDUCATION_CESS' )
708: AND SOURCE_TRX_TYPE IN ( 'ADJUSTMENT-RECOVERY' , 'RECOVERY' )

Line 741: JAI_RGM_TRX_RECORDS

737: SELECT
738: NVL(SUM(DEBIT_AMOUNT)
739: ,0)
740: FROM
741: JAI_RGM_TRX_RECORDS
742: WHERE SOURCE = 'SERVICE_DISTRIBUTE_OUT'
743: AND REGIME_CODE = 'SERVICE'
744: AND TAX_TYPE IN ( 'SERVICE_EDUCATION_CESS' )
745: AND REGIME_PRIMARY_REGNO = PRM_RGM_PRIM_REGNO

Line 757: JAI_RGM_TRX_RECORDS

753: SELECT
754: NVL(SUM(DEBIT_AMOUNT)
755: ,0)
756: FROM
757: JAI_RGM_TRX_RECORDS
758: WHERE SOURCE = 'MANUAL'
759: AND REGIME_CODE = 'SERVICE'
760: AND TAX_TYPE IN ( 'SERVICE_EDUCATION_CESS' )
761: AND SOURCE_TRX_TYPE IN ( 'ADJUSTMENT-LIABILITY' , 'LIABILITY' )

Line 774: JAI_RGM_TRX_RECORDS

770: SELECT
771: NVL(SUM(DEBIT_AMOUNT)
772: ,0)
773: FROM
774: JAI_RGM_TRX_RECORDS
775: WHERE SOURCE = 'MANUAL'
776: AND REGIME_CODE = 'SERVICE'
777: AND TAX_TYPE IN ( 'SERVICE_EDUCATION_CESS' )
778: AND SOURCE_TRX_TYPE = 'PAYMENT'

Line 839: JAI_RGM_TRX_RECORDS TRXRECS,

835: CURSOR C_SERV_CREDIT(CPV_ITEM_CLASS IN VARCHAR2) IS
836: SELECT
837: SUM(TRXRECS.CREDIT_AMOUNT) EDU_CESS_CREDIT
838: FROM
839: JAI_RGM_TRX_RECORDS TRXRECS,
840: JAI_RGM_TRX_REFS TRXREFS,
841: AP_INVOICES_ALL APA,
842: JAI_CMN_VENDOR_SITES JPVS,
843: PO_VENDOR_SITES_ALL PVSA,

Line 873: JAI_RGM_TRX_RECORDS JRTR,

869: CURSOR C_SERV_CREDIT_1(CPV_ITEM_CLASS IN VARCHAR2) IS
870: SELECT
871: SUM(JRTR.CREDIT_AMOUNT) EDU_CESS_CREDIT
872: FROM
873: JAI_RGM_TRX_RECORDS JRTR,
874: JAI_RGM_MANUAL_TRXS JMT,
875: PO_VENDOR_SITES_ALL PVSA
876: WHERE JRTR.SOURCE = 'MANUAL'
877: AND JRTR.REGIME_CODE = 'SERVICE'

Line 893: LN_SERV_CREDIT_RMIN JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;

889: ,JRTR.ORGANIZATION_ID)
890: AND JRTR.SERVICE_TYPE_CODE = NVL(PRM_SERVICE_TYPE
891: ,JRTR.SERVICE_TYPE_CODE)
892: AND JRTR.TAX_TYPE = 'SERVICE_EDUCATION_CESS';
893: LN_SERV_CREDIT_RMIN JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
894: LN_SERV_CREDIT_RM JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
895: LN_SERV_CREDIT_CGIN JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
896: LN_SERV_CREDIT_FG JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
897: BEGIN

Line 894: LN_SERV_CREDIT_RM JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;

890: AND JRTR.SERVICE_TYPE_CODE = NVL(PRM_SERVICE_TYPE
891: ,JRTR.SERVICE_TYPE_CODE)
892: AND JRTR.TAX_TYPE = 'SERVICE_EDUCATION_CESS';
893: LN_SERV_CREDIT_RMIN JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
894: LN_SERV_CREDIT_RM JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
895: LN_SERV_CREDIT_CGIN JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
896: LN_SERV_CREDIT_FG JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
897: BEGIN
898: LV_DATE := MONTH1 || '-' || YEAR1;

Line 895: LN_SERV_CREDIT_CGIN JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;

891: ,JRTR.SERVICE_TYPE_CODE)
892: AND JRTR.TAX_TYPE = 'SERVICE_EDUCATION_CESS';
893: LN_SERV_CREDIT_RMIN JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
894: LN_SERV_CREDIT_RM JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
895: LN_SERV_CREDIT_CGIN JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
896: LN_SERV_CREDIT_FG JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
897: BEGIN
898: LV_DATE := MONTH1 || '-' || YEAR1;
899: OPEN C_SERV_CREDIT('RMIN');

Line 896: LN_SERV_CREDIT_FG JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;

892: AND JRTR.TAX_TYPE = 'SERVICE_EDUCATION_CESS';
893: LN_SERV_CREDIT_RMIN JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
894: LN_SERV_CREDIT_RM JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
895: LN_SERV_CREDIT_CGIN JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
896: LN_SERV_CREDIT_FG JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE;
897: BEGIN
898: LV_DATE := MONTH1 || '-' || YEAR1;
899: OPEN C_SERV_CREDIT('RMIN');
900: FETCH C_SERV_CREDIT

Line 937: JAI_RGM_TRX_RECORDS

933: SELECT
934: NVL(SUM(DEBIT_AMOUNT)
935: ,0) DEBIT
936: FROM
937: JAI_RGM_TRX_RECORDS
938: WHERE SOURCE = 'SERVICE_DISTRIBUTE_OUT'
939: AND REGIME_CODE = 'SERVICE'
940: AND TAX_TYPE = 'Service'
941: AND REGIME_PRIMARY_REGNO = PRM_RGM_PRIM_REGNO

Line 953: LN_DEBIT_AMOUNT JAI_RGM_TRX_RECORDS.DEBIT_AMOUNT%TYPE;

949: AND TO_CHAR(CREATION_DATE
950: ,'MON-YYYY') = LV_DATE
951: AND ORGANIZATION_ID = NVL(PRM_ORG_ID
952: ,ORGANIZATION_ID);
953: LN_DEBIT_AMOUNT JAI_RGM_TRX_RECORDS.DEBIT_AMOUNT%TYPE;
954: BEGIN
955: LV_DATE := MONTH1 || '-' || YEAR1;
956: OPEN CUR_AR_SER_DIST_OUT_DEBIT;
957: FETCH CUR_AR_SER_DIST_OUT_DEBIT

Line 976: JAI_RGM_TRX_RECORDS

972: SELECT
973: NVL(SUM(DEBIT_AMOUNT)
974: ,0) DEBIT
975: FROM
976: JAI_RGM_TRX_RECORDS
977: WHERE SOURCE = 'SERVICE_DISTRIBUTE_OUT'
978: AND REGIME_CODE = 'SERVICE'
979: AND TAX_TYPE = 'SERVICE_EDUCATION_CESS'
980: AND REGIME_PRIMARY_REGNO = PRM_RGM_PRIM_REGNO

Line 992: LN_DEBIT_AMOUNT JAI_RGM_TRX_RECORDS.DEBIT_AMOUNT%TYPE;

988: AND SERVICE_TYPE_CODE = NVL(PRM_SERVICE_TYPE
989: ,SERVICE_TYPE_CODE)
990: AND ORGANIZATION_ID = NVL(PRM_ORG_ID
991: ,ORGANIZATION_ID);
992: LN_DEBIT_AMOUNT JAI_RGM_TRX_RECORDS.DEBIT_AMOUNT%TYPE;
993: BEGIN
994: LV_DATE := MONTH1 || '-' || YEAR1;
995: /*SRW.MESSAGE(1275
996: ,LV_DATE)*/NULL;