APPS.JA_JAINST3_XMLP_PKG dependencies on AP_INVOICES_ALL

Line 78: AP_INVOICES_ALL INVC,

74: INVC.INVOICE_NUM INVOICE_NUM,
75: INVC.INVOICE_DATE INVOICE_DATE
76: FROM
77: AP_INVOICE_PAYMENTS_ALL INVCPAY,
78: AP_INVOICES_ALL INVC,
79: PO_VENDOR_SITES_ALL VENDSITES,
80: PO_VENDORS VENDS
81: WHERE INVCPAY.INVOICE_ID = INVC.INVOICE_ID
82: AND INVC.VENDOR_ID = VENDSITES.VENDOR_ID

Line 92: LV_INVOICE_NUM AP_INVOICES_ALL.INVOICE_NUM%TYPE;

88: AND VENDS.VENDOR_TYPE_LOOKUP_CODE = 'Service Tax Authorities'
89: AND TO_CHAR(INVCPAY.CREATION_DATE
90: ,'MON-YYYY') = LV_MON_YEAR
91: AND ROWNUM = 1;
92: LV_INVOICE_NUM AP_INVOICES_ALL.INVOICE_NUM%TYPE;
93: BEGIN
94: LV_MON_YEAR := MONTH || '-' || YEAR;
95: OPEN C_INVOICE;
96: FETCH C_INVOICE

Line 321: AP_INVOICES_ALL APA,

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
325: WHERE TRXREFS.REFERENCE_ID = TRXRECS.REFERENCE_ID

Line 563: AP_INVOICES_ALL APA,

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
567: WHERE TRXREFS.REFERENCE_ID = TRXRECS.REFERENCE_ID

Line 841: AP_INVOICES_ALL APA,

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
845: WHERE TRXREFS.REFERENCE_ID = TRXRECS.REFERENCE_ID