APPS.JA_JAINST3_XMLP_PKG dependencies on JAI_RGM_TRX_REFS

Line 149: JAI_RGM_TRX_REFS

145: CURSOR CUR_INVOICE_OPEN_BAL IS
146: SELECT
147: SUM(RECOVERED_AMOUNT)
148: FROM
149: JAI_RGM_TRX_REFS
150: WHERE SOURCE = 'AP'
151: AND TAX_TYPE in ( 'Service' )
152: AND TRUNC(CREATION_DATE) < LV_DATE
153: AND JAI_TRX_REPO_EXTRACT_PKG.GET_SERVICE_TYPE_FROM_REF(REFERENCE_ID) = PRM_SERVICE_TYPE

Line 200: JAI_RGM_TRX_REFS

196: CURSOR CUR_AR_UTIL_CREDIT IS
197: SELECT
198: SUM(RECOVERED_AMOUNT)
199: FROM
200: JAI_RGM_TRX_REFS
201: WHERE SOURCE = 'AR'
202: AND TAX_TYPE in ( 'Service' )
203: AND TRUNC(CREATION_DATE) < LV_DATE
204: AND JAI_TRX_REPO_EXTRACT_PKG.GET_SERVICE_TYPE_FROM_REF(REFERENCE_ID) = PRM_SERVICE_TYPE

Line 320: JAI_RGM_TRX_REFS TRXREFS,

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,
324: JAI_INV_ITM_SETUPS JMSI

Line 439: JAI_RGM_TRX_REFS TRXREFS

435: CURSOR CUR_AR_UTIL_CREDIT IS
436: SELECT
437: SUM(RECOVERED_AMOUNT)
438: FROM
439: JAI_RGM_TRX_REFS TRXREFS
440: WHERE SOURCE = 'AR'
441: AND TAX_TYPE in ( 'Service' , 'SERVICE_EDUCATION_CESS' )
442: AND ORGANIZATION_ID IN (
443: SELECT

Line 562: JAI_RGM_TRX_REFS TRXREFS,

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,
566: JAI_INV_ITM_SETUPS JMSI

Line 669: JAI_RGM_TRX_REFS

665: CURSOR CUR_INVOICE_OPEN_BAL IS
666: SELECT
667: SUM(RECOVERED_AMOUNT)
668: FROM
669: JAI_RGM_TRX_REFS
670: WHERE SOURCE = 'AP'
671: AND TAX_TYPE in ( 'SERVICE_EDUCATION_CESS' )
672: AND TRUNC(CREATION_DATE) < LV_DATE
673: AND JAI_TRX_REPO_EXTRACT_PKG.GET_SERVICE_TYPE_FROM_REF(REFERENCE_ID) = PRM_SERVICE_TYPE

Line 720: JAI_RGM_TRX_REFS

716: CURSOR CUR_AR_UTIL_CREDIT IS
717: SELECT
718: SUM(RECOVERED_AMOUNT)
719: FROM
720: JAI_RGM_TRX_REFS
721: WHERE SOURCE = 'AR'
722: AND TAX_TYPE in ( 'SERVICE_EDUCATION_CESS' )
723: AND TRUNC(CREATION_DATE) < LV_DATE
724: AND JAI_TRX_REPO_EXTRACT_PKG.GET_SERVICE_TYPE_FROM_REF(REFERENCE_ID) = PRM_SERVICE_TYPE

Line 840: JAI_RGM_TRX_REFS TRXREFS,

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,
844: JAI_INV_ITM_SETUPS JMSI