DBA Data[Home] [Help]

APPS.AP_BANKACCT_INACTIVE_WF_PKG dependencies on FND_GLOBAL

Line 205: aps.last_updated_by = FND_GLOBAL.user_id,

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
207: WHERE aps.invoice_id IN
208: (SELECT DISTINCT ai.invoice_id
209: FROM ap_invoices_all ai, ap_payment_schedules_all aps1

Line 206: aps.last_update_login = FND_GLOBAL.login_id

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
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

Line 230: aps.last_updated_by = FND_GLOBAL.user_id,

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
232: WHERE aps.invoice_id IN
233: (SELECT DISTINCT ai.invoice_id
234: FROM ap_invoices_all ai, ap_payment_schedules_all aps1

Line 231: aps.last_update_login = FND_GLOBAL.login_id

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
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

Line 256: aps.last_updated_by = FND_GLOBAL.user_id,

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
258: WHERE aps.invoice_id IN
259: (SELECT DISTINCT ai.invoice_id
260: FROM ap_invoices_all ai, ap_payment_schedules_all aps1

Line 257: aps.last_update_login = FND_GLOBAL.login_id

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
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