APPS.AP_BANKACCT_INACTIVE_WF_PKG dependencies on AP_PAYMENT_SCHEDULES_ALL

Line 202: UPDATE ap_payment_schedules_all aps

198: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
199: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
200: END IF;
201:
202: UPDATE ap_payment_schedules_all aps
203: SET aps.external_bank_account_id = l_extbank_acct_id,
204: aps.last_update_date = SYSDATE,
205: aps.last_updated_by = FND_GLOBAL.user_id,
206: aps.last_update_login = FND_GLOBAL.login_id

Line 209: FROM ap_invoices_all ai, ap_payment_schedules_all aps1

205: aps.last_updated_by = FND_GLOBAL.user_id,
206: aps.last_update_login = FND_GLOBAL.login_id
207: WHERE aps.invoice_id IN
208: (SELECT DISTINCT ai.invoice_id
209: FROM ap_invoices_all ai, ap_payment_schedules_all aps1
210: WHERE aps1.external_bank_account_id = P_bank_account_id
211: AND ai.invoice_id = aps1.invoice_id
212: AND ai.org_id = l_org_id
213: AND ai.payment_status_flag IN ('N','P')

Line 227: UPDATE ap_payment_schedules_all aps

223: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
224: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
225: END IF;
226:
227: UPDATE ap_payment_schedules_all aps
228: SET aps.external_bank_account_id = l_extbank_acct_id,
229: aps.last_update_date = SYSDATE,
230: aps.last_updated_by = FND_GLOBAL.user_id,
231: aps.last_update_login = FND_GLOBAL.login_id

Line 234: FROM ap_invoices_all ai, ap_payment_schedules_all aps1

230: aps.last_updated_by = FND_GLOBAL.user_id,
231: aps.last_update_login = FND_GLOBAL.login_id
232: WHERE aps.invoice_id IN
233: (SELECT DISTINCT ai.invoice_id
234: FROM ap_invoices_all ai, ap_payment_schedules_all aps1
235: WHERE aps1.external_bank_account_id = P_bank_account_id
236: AND ai.invoice_id = aps1.invoice_id
237: AND ai.payment_status_flag IN ('N','P')
238: AND ai.cancelled_date IS NULL

Line 253: UPDATE ap_payment_schedules_all aps

249: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
250: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
251: END IF;
252:
253: UPDATE ap_payment_schedules_all aps
254: SET aps.external_bank_account_id = l_extbank_acct_id,
255: aps.last_update_date = SYSDATE,
256: aps.last_updated_by = FND_GLOBAL.user_id,
257: aps.last_update_login = FND_GLOBAL.login_id

Line 260: FROM ap_invoices_all ai, ap_payment_schedules_all aps1

256: aps.last_updated_by = FND_GLOBAL.user_id,
257: aps.last_update_login = FND_GLOBAL.login_id
258: WHERE aps.invoice_id IN
259: (SELECT DISTINCT ai.invoice_id
260: FROM ap_invoices_all ai, ap_payment_schedules_all aps1
261: WHERE aps1.external_bank_account_id = P_bank_account_id
262: AND ai.invoice_id = aps1.invoice_id
263: AND ai.payment_status_flag IN ('N','P')
264: AND ai.cancelled_date IS NULL