DBA Data[Home] [Help]

APPS.AP_WEB_OA_ACTIVE_PKG dependencies on AP_INVOICES_ALL

Line 548: AP_INVOICES_ALL AI,

544: 'P','PARPAID',NULL)),
545: 'CANCELLED')
546: INTO l_final_status_code
547: FROM
548: AP_INVOICES_ALL AI,
549: AP_EXPENSE_REPORT_HEADERS_ALL AERH,
550: AP_PAYMENT_SCHEDULES_ALL APS
551: WHERE AERH.VOUCHNO = AI.INVOICE_ID
552: AND AERH.BOTHPAY_PARENT_ID = p_report_header_id

Line 575: AP_INVOICES_ALL AI,

571: 'P','PARPAID',NULL)),
572: 'CANCELLED')
573: INTO l_cc_report_status_code
574: FROM
575: AP_INVOICES_ALL AI,
576: AP_EXPENSE_REPORT_HEADERS_ALL AERH,
577: AP_PAYMENT_SCHEDULES_ALL APS
578: WHERE AERH.VOUCHNO = AI.INVOICE_ID
579: AND AERH.BOTHPAY_PARENT_ID = p_report_header_id