APPS.AP_WEB_OA_ACTIVE_PKG dependencies on AP_INVOICES_ALL

Line 569: AP_INVOICES_ALL AI,

565: 'P','PARPAID',NULL)),
566: 'CANCELLED')
567: INTO l_final_status_code
568: FROM
569: AP_INVOICES_ALL AI,
570: AP_EXPENSE_REPORT_HEADERS_ALL AERH,
571: AP_PAYMENT_SCHEDULES_ALL APS
572: WHERE AERH.VOUCHNO = AI.INVOICE_ID
573: AND AERH.BOTHPAY_PARENT_ID = p_report_header_id

Line 596: AP_INVOICES_ALL AI,

592: 'P','PARPAID',NULL)),
593: 'CANCELLED')
594: INTO l_cc_report_status_code
595: FROM
596: AP_INVOICES_ALL AI,
597: AP_EXPENSE_REPORT_HEADERS_ALL AERH,
598: AP_PAYMENT_SCHEDULES_ALL APS
599: WHERE AERH.VOUCHNO = AI.INVOICE_ID
600: AND AERH.BOTHPAY_PARENT_ID = p_report_header_id