APPS.FV_BA_UPG_PKG dependencies on CE_UPG_BANK_ACCTS_GT

Line 15: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'updating ce_upg_bank_accts_gt for fv_ar_batches');

11: BEGIN
12:
13: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
14: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'fv_ba_upg_pkg.ap_acct_in_use()+');
15: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'updating ce_upg_bank_accts_gt for fv_ar_batches');
16: END IF;
17:
18: update ce_upg_bank_accts_gt ce
19: set acct_in_use_flag = 'Y'

Line 18: update ce_upg_bank_accts_gt ce

14: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'fv_ba_upg_pkg.ap_acct_in_use()+');
15: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'updating ce_upg_bank_accts_gt for fv_ar_batches');
16: END IF;
17:
18: update ce_upg_bank_accts_gt ce
19: set acct_in_use_flag = 'Y'
20: where exists
21: (SELECT null FROM fv_ar_batches_all fab
22: WHERE fab.bank_account_id = ce.bank_account_id)

Line 26: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'updating ce_upg_bank_accts_gt for fv_interim_cash_receipts');

22: WHERE fab.bank_account_id = ce.bank_account_id)
23: and acct_in_use_flag = 'N';
24:
25: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
26: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'updating ce_upg_bank_accts_gt for fv_interim_cash_receipts');
27: END IF;
28:
29: update ce_upg_bank_accts_gt ce
30: set acct_in_use_flag = 'Y'

Line 29: update ce_upg_bank_accts_gt ce

25: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
26: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'updating ce_upg_bank_accts_gt for fv_interim_cash_receipts');
27: END IF;
28:
29: update ce_upg_bank_accts_gt ce
30: set acct_in_use_flag = 'Y'
31: where exists
32: (SELECT null FROM fv_interim_cash_receipts_all ficr
33: WHERE ficr.bank_account_id = ce.bank_account_id)