APPS.AP_CANCEL_PKG dependencies on AP_CHECKS

Line 196: from ap_checks A

192: AND PS.payment_status_flag <> 'N'
193: AND nvl(P.reversal_flag,'N') <> 'Y'
194: AND P.amount is not NULL
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(*)

Line 208: FROM ap_checks A

204: AND NVL(P.reversal_flag,'N') <> 'Y'
205: AND P.amount IS NOT NULL
206: AND EXISTS
207: (SELECT 'non void check'
208: FROM ap_checks A
209: WHERE A.check_id = P.check_id
210: AND void_date IS NULL
211: );
212: