517:
518: --Check if report is split or not, if it is not split it will throw the exception
519: SELECT AERH.VOUCHNO, AERH.EXPENSE_STATUS_CODE
520: INTO l_cc_vouch_no, l_org_cc_report_status_code
521: FROM AP_EXPENSE_REPORT_HEADERS_ALL AERH
522: WHERE AERH.BOTHPAY_PARENT_ID=p_report_header_id;
523:
524:
525: --Report is split
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
553: AND AI.INVOICE_TYPE_LOOKUP_CODE = 'MIXED'
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
580: AND AI.INVOICE_TYPE_LOOKUP_CODE = 'MIXED'