859: p_checkrun_id IN NUMBER)
860: RETURN VARCHAR2 IS
861:
862: BEGIN
863: UPDATE ap_payment_schedules_all APS
864: SET APS.checkrun_id = p_checkrun_id
865: WHERE (APS.invoice_id, APS.payment_num ) IN
866: (SELECT ASI.invoice_id, ASI.payment_num
867: FROM ap_selected_invoices_all ASI