APPS.JA_JAINER1_XMLP_PKG dependencies on JAI_RGM_TRX_REFS

Line 383: JAI_RGM_TRX_REFS JRTF1,

379: ( SELECT
380: JRTF1.RECOVERED_AMOUNT SERVICE_CREDIT,
381: JRTF2.RECOVERED_AMOUNT EDU_CESS_CREDIT
382: FROM
383: JAI_RGM_TRX_REFS JRTF1,
384: JAI_RGM_TRX_REFS JRTF2
385: WHERE JRTF1.SOURCE = 'AP'
386: AND JRTF1.INVOICE_ID = jrtf2.invoice_id (+)
387: AND JRTF1.TAX_TYPE = 'Service'

Line 384: JAI_RGM_TRX_REFS JRTF2

380: JRTF1.RECOVERED_AMOUNT SERVICE_CREDIT,
381: JRTF2.RECOVERED_AMOUNT EDU_CESS_CREDIT
382: FROM
383: JAI_RGM_TRX_REFS JRTF1,
384: JAI_RGM_TRX_REFS JRTF2
385: WHERE JRTF1.SOURCE = 'AP'
386: AND JRTF1.INVOICE_ID = jrtf2.invoice_id (+)
387: AND JRTF1.TAX_TYPE = 'Service'
388: AND jrtf2.tax_type (+) = TAX_TYPE_SERVICE_EDU_CESS

Line 456: JAI_RGM_TRX_REFS JRTF1,

452: ( SELECT
453: JRTF1.RECOVERED_AMOUNT SERVICE_CREDIT,
454: JRTF2.RECOVERED_AMOUNT EDU_CESS_CREDIT
455: FROM
456: JAI_RGM_TRX_REFS JRTF1,
457: JAI_RGM_TRX_REFS JRTF2
458: WHERE JRTF1.SOURCE = 'AP'
459: AND JRTF1.INVOICE_ID = jrtf2.invoice_id (+)
460: AND JRTF1.TAX_TYPE = 'Service'

Line 457: JAI_RGM_TRX_REFS JRTF2

453: JRTF1.RECOVERED_AMOUNT SERVICE_CREDIT,
454: JRTF2.RECOVERED_AMOUNT EDU_CESS_CREDIT
455: FROM
456: JAI_RGM_TRX_REFS JRTF1,
457: JAI_RGM_TRX_REFS JRTF2
458: WHERE JRTF1.SOURCE = 'AP'
459: AND JRTF1.INVOICE_ID = jrtf2.invoice_id (+)
460: AND JRTF1.TAX_TYPE = 'Service'
461: AND jrtf2.tax_type (+) = TAX_TYPE_SH_SERVICE_EDU_CESS

Line 544: JAI_RGM_TRX_REFS

540: CURSOR CUR_AR_UTIL_CREDIT IS
541: SELECT
542: SUM(RECOVERED_AMOUNT)
543: FROM
544: JAI_RGM_TRX_REFS
545: WHERE SOURCE = 'AR'
546: AND TAX_TYPE = 'Service'
547: AND ORGANIZATION_ID IN (
548: SELECT

Line 652: JAI_RGM_TRX_REFS

648: CURSOR CUR_AR_UTIL_CREDIT IS
649: SELECT
650: SUM(RECOVERED_AMOUNT)
651: FROM
652: JAI_RGM_TRX_REFS
653: WHERE SOURCE = 'AR'
654: AND TAX_TYPE = TAX_TYPE_SERVICE_EDU_CESS
655: AND ORGANIZATION_ID IN (
656: SELECT

Line 903: JAI_RGM_TRX_REFS

899: CURSOR CUR_INVOICE_OPEN_BAL IS
900: SELECT
901: SUM(RECOVERED_AMOUNT)
902: FROM
903: JAI_RGM_TRX_REFS
904: WHERE SOURCE = 'AP'
905: AND TAX_TYPE = 'Service'
906: AND TRUNC(CREATION_DATE) < P_START_DATE
907: AND ORGANIZATION_ID in (

Line 953: JAI_RGM_TRX_REFS

949: CURSOR CUR_AR_UTIL_CREDIT IS
950: SELECT
951: SUM(RECOVERED_AMOUNT)
952: FROM
953: JAI_RGM_TRX_REFS
954: WHERE SOURCE = 'AR'
955: AND TAX_TYPE = 'Service'
956: AND TRUNC(CREATION_DATE) < P_START_DATE
957: AND ORGANIZATION_ID IN (

Line 1069: JAI_RGM_TRX_REFS

1065: CURSOR CUR_INVOICE_OPEN_BAL IS
1066: SELECT
1067: SUM(RECOVERED_AMOUNT)
1068: FROM
1069: JAI_RGM_TRX_REFS
1070: WHERE SOURCE = 'AP'
1071: AND TAX_TYPE = TAX_TYPE_SERVICE_EDU_CESS
1072: AND TRUNC(CREATION_DATE) < P_START_DATE
1073: AND ORGANIZATION_ID in (

Line 1119: JAI_RGM_TRX_REFS

1115: CURSOR CUR_AR_UTIL_CREDIT IS
1116: SELECT
1117: SUM(RECOVERED_AMOUNT)
1118: FROM
1119: JAI_RGM_TRX_REFS
1120: WHERE SOURCE = 'AR'
1121: AND TAX_TYPE = TAX_TYPE_SERVICE_EDU_CESS
1122: AND TRUNC(CREATION_DATE) < P_START_DATE
1123: AND ORGANIZATION_ID IN (

Line 2918: JAI_RGM_TRX_REFS

2914: CURSOR CUR_INVOICE_OPEN_BAL IS
2915: SELECT
2916: SUM(RECOVERED_AMOUNT)
2917: FROM
2918: JAI_RGM_TRX_REFS
2919: WHERE SOURCE = 'AP'
2920: AND TAX_TYPE = TAX_TYPE_SH_SERVICE_EDU_CESS
2921: AND TRUNC(CREATION_DATE) < P_START_DATE
2922: AND ORGANIZATION_ID in (

Line 2968: JAI_RGM_TRX_REFS

2964: CURSOR CUR_AR_UTIL_CREDIT IS
2965: SELECT
2966: SUM(RECOVERED_AMOUNT)
2967: FROM
2968: JAI_RGM_TRX_REFS
2969: WHERE SOURCE = 'AR'
2970: AND TAX_TYPE = TAX_TYPE_SH_SERVICE_EDU_CESS
2971: AND TRUNC(CREATION_DATE) < P_START_DATE
2972: AND ORGANIZATION_ID IN (

Line 3189: JAI_RGM_TRX_REFS

3185: CURSOR CUR_AR_UTIL_CREDIT IS
3186: SELECT
3187: SUM(RECOVERED_AMOUNT)
3188: FROM
3189: JAI_RGM_TRX_REFS
3190: WHERE SOURCE = 'AR'
3191: AND TAX_TYPE = TAX_TYPE_SH_SERVICE_EDU_CESS
3192: AND ORGANIZATION_ID IN (
3193: SELECT