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: --Bug10034598: Commected below query
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 199: --Bug10034598 : Removed join with ap_payment_schedules

195: AND exists ( select 'non void check'
196: from ap_checks A
197: where A.check_id = P.check_id
198: and void_date is null);*/--Bug 6135172
199: --Bug10034598 : Removed join with ap_payment_schedules
200: SELECT COUNT(*)
201: INTO l_payment_count
202: FROM ap_invoice_payments P
203: WHERE P.invoice_id = P_invoice_id

Line 778: UPDATE ap_payment_schedules

774: +-----------------------------------------------------------------*/
775:
776: l_debug_info := 'Clear out payment schedules';
777:
778: UPDATE ap_payment_schedules
779: SET gross_amount = 0
780: ,amount_remaining = 0
781: ,payment_status_flag = 'N'
782: ,hold_flag = 'N'

Line 790: (p_table_name => 'AP_PAYMENT_SCHEDULES',

786: WHERE invoice_id = P_invoice_id;
787:
788: --Bug 4539462 DBI logging
789: AP_DBI_PKG.Maintain_DBI_Summary
790: (p_table_name => 'AP_PAYMENT_SCHEDULES',
791: p_operation => 'U',
792: p_key_value1 => P_invoice_id,
793: p_calling_sequence => l_curr_calling_sequence);
794: