APPS.AP_CANCEL_PKG dependencies on AP_PAYMENT_SCHEDULES

Line 58: FROM ap_payment_schedules

54: IS
55:
56: CURSOR verify_no_pay_batch IS
57: SELECT checkrun_id
58: FROM ap_payment_schedules
59: WHERE invoice_id = P_invoice_id
60: FOR UPDATE NOWAIT;
61:
62: -- Bug5497058

Line 189: FROM ap_invoice_payments P,ap_payment_schedules PS

185: l_debug_info := 'Check if invoice has an effective payment';
186:
187: SELECT count(*)
188: INTO l_payment_count
189: FROM ap_invoice_payments P,ap_payment_schedules PS
190: WHERE P.invoice_id=PS.invoice_id
191: AND P.invoice_id = P_invoice_id
192: AND PS.payment_status_flag <> 'N'
193: AND nvl(P.reversal_flag,'N') <> 'Y'

Line 707: UPDATE ap_payment_schedules

703: +-----------------------------------------------------------------*/
704:
705: l_debug_info := 'Clear out payment schedules';
706:
707: UPDATE ap_payment_schedules
708: SET gross_amount = 0
709: ,amount_remaining = 0
710: ,payment_status_flag = 'N'
711: ,hold_flag = 'N'

Line 719: (p_table_name => 'AP_PAYMENT_SCHEDULES',

715: WHERE invoice_id = P_invoice_id;
716:
717: --Bug 4539462 DBI logging
718: AP_DBI_PKG.Maintain_DBI_Summary
719: (p_table_name => 'AP_PAYMENT_SCHEDULES',
720: p_operation => 'U',
721: p_key_value1 => P_invoice_id,
722: p_calling_sequence => l_curr_calling_sequence);
723: