APPS.CE_AUTO_BANK_UNREC dependencies on CE_BANK_ACCOUNTS

Line 67: FROM CE_BANK_ACCOUNTS

63:
64: /* 2853915 Added the nvl condition for statement_header_number */
65: CURSOR C_oifs(P_BANK_ACCOUNT_ID number) IS
66: SELECT RECON_OI_FLOAT_STATUS
67: FROM CE_BANK_ACCOUNTS
68: WHERE BANK_ACCOUNT_ID = NVL(X_bank_account_id, P_BANK_ACCOUNT_ID);
69:
70: /* SELECT open_interface_float_status
71: FROM CE_SYSTEM_PARAMETERS_ALL sys

Line 73: from CE_BANK_ACCOUNTS --ACCTS_GT_V --ce_BANK_ACCOUNTS_v

69:
70: /* SELECT open_interface_float_status
71: FROM CE_SYSTEM_PARAMETERS_ALL sys
72: where exists ( select ACCOUNT_OWNER_ORG_ID
73: from CE_BANK_ACCOUNTS --ACCTS_GT_V --ce_BANK_ACCOUNTS_v
74: where bank_account_id = X_bank_account_id
75: and ACCOUNT_OWNER_ORG_ID = sys.legal_entity_id);*/
76:
77: l_cnt NUMBER := 0;

Line 197: ce_bank_accounts ba

193: SELECT count(1)
194: INTO l_count_ap_ar /* 13644150: count for ap/ar period */
195: FROM gl_period_statuses glp,
196: ce_system_parameters sys,
197: ce_bank_accounts ba
198: WHERE glp.application_id = l_app_id
199: AND glp.set_of_books_id = sys.set_of_books_id
200: AND glp.adjustment_period_flag = 'N'
201: AND glp.closing_status in ('O','F')

Line 216: ce_bank_accounts ba

212: SELECT count(1)
213: INTO l_count
214: FROM gl_period_statuses glp,
215: ce_system_parameters sys,
216: ce_bank_accounts ba
217: WHERE glp.application_id = 101
218: AND glp.set_of_books_id = sys.set_of_books_id
219: AND glp.adjustment_period_flag = 'N'
220: AND glp.closing_status in ('O','F')