APPS.CE_AUTO_BANK_UNREC dependencies on CE_BANK_ACCOUNTS

Line 74: FROM CE_BANK_ACCOUNTS

70: Added the nvl condition for statement_header_number */
71:
72: CURSOR C_oifs(P_BANK_ACCOUNT_ID number) IS
73: SELECT RECON_OI_FLOAT_STATUS
74: FROM CE_BANK_ACCOUNTS
75: WHERE BANK_ACCOUNT_ID = NVL(X_bank_account_id, P_BANK_ACCOUNT_ID);
76:
77: /* SELECT open_interface_float_status
78: FROM CE_SYSTEM_PARAMETERS_ALL sys

Line 80: from CE_BANK_ACCOUNTS --ACCTS_GT_V --ce_BANK_ACCOUNTS_v

76:
77: /* SELECT open_interface_float_status
78: FROM CE_SYSTEM_PARAMETERS_ALL sys
79: where exists ( select ACCOUNT_OWNER_ORG_ID
80: from CE_BANK_ACCOUNTS --ACCTS_GT_V --ce_BANK_ACCOUNTS_v
81: where bank_account_id = X_bank_account_id
82: and ACCOUNT_OWNER_ORG_ID = sys.legal_entity_id);*/
83:
84: l_cnt NUMBER := 0;

Line 199: ce_bank_accounts ba

195: SELECT count(1)
196: INTO l_count
197: FROM gl_period_statuses glp,
198: ce_system_parameters sys,
199: ce_bank_accounts ba
200: WHERE glp.application_id = l_app_id
201: AND glp.set_of_books_id = sys.set_of_books_id
202: AND glp.adjustment_period_flag = 'N'
203: AND glp.closing_status in ('O','F')