DBA Data[Home] [Help]

APPS.JL_BR_AR_CANCEL_BORDERO dependencies on AR_PAYMENT_SCHEDULES

Line 162: UPDATE AR_PAYMENT_SCHEDULES SET

158: AND payment_schedule_id = var_payment_schedule
159: AND document_id = var_document_id;
160:
161: IF var_bordero_action = 'Y' THEN
162: UPDATE AR_PAYMENT_SCHEDULES SET
163: global_attribute12 = var_document_status, --bug 12606008
164: global_attribute11 = 'N',
165: global_attribute9 = 'MANUAL_RECEIPT' --bug 8971675
166: WHERE payment_schedule_id = var_payment_schedule;

Line 168: UPDATE AR_PAYMENT_SCHEDULES SET

164: global_attribute11 = 'N',
165: global_attribute9 = 'MANUAL_RECEIPT' --bug 8971675
166: WHERE payment_schedule_id = var_payment_schedule;
167: ELSE
168: UPDATE AR_PAYMENT_SCHEDULES SET
169: global_attribute12 = var_document_status, --bug 12606008
170: global_attribute13 = NULL, --bug 12636807
171: global_attribute14 = NULL, --bug 12636807
172: selected_for_receipt_batch_id = NULL,