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
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