156: AND payment_schedule_id = var_payment_schedule
157: AND document_id = var_document_id;
158:
159: IF var_bordero_action = 'Y' THEN
160: UPDATE AR_PAYMENT_SCHEDULES SET
161: global_attribute11 = 'N'
162: WHERE payment_schedule_id = var_payment_schedule;
163: ELSE
164: UPDATE AR_PAYMENT_SCHEDULES SET
160: UPDATE AR_PAYMENT_SCHEDULES SET
161: global_attribute11 = 'N'
162: WHERE payment_schedule_id = var_payment_schedule;
163: ELSE
164: UPDATE AR_PAYMENT_SCHEDULES SET
165: selected_for_receipt_batch_id = NULL,
166: global_attribute11 = 'N'
167: WHERE payment_schedule_id = var_payment_schedule;
168: END IF;