APPS.JE_JEPLPSSR_XMLP_PKG dependencies on AP_INVOICES_ALL

Line 599: AP_INVOICES_ALL AI

595: NAME
596: INTO L_NAME
597: FROM
598: FND_DOC_SEQUENCE_CATEGORIES FDOC,
599: AP_INVOICES_ALL AI
600: WHERE AI.INVOICE_ID = TRANS_ID
601: AND FDOC.CODE = AI.DOC_CATEGORY_CODE
602: AND FDOC.APPLICATION_ID = 200;
603: RETURN (L_NAME);

Line 668: AP_INVOICES_ALL AI,

664: SELECT
665: SUM(NVL(AID.PREPAY_AMOUNT_REMAINING,AID.AMOUNT)) * - 1
666: INTO L_PREPAY_AMOUNT
667: FROM
668: AP_INVOICES_ALL AI,
669: AP_INVOICE_DISTRIBUTIONS_ALL AID,
670: AP_LOOKUP_CODES ALC
671: WHERE AID.ACCOUNTING_DATE <= P_END_DATE
672: AND AI.INVOICE_TYPE_LOOKUP_CODE = 'PREPAYMENT'