APPS.CE_AUTO_BANK_UNREC dependencies on CE_SYSTEM_PARAMETERS

Line 71: FROM CE_SYSTEM_PARAMETERS_ALL sys

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
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);*/

Line 196: ce_system_parameters sys,

192: -- Check to see if period is open or future
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'

Line 215: ce_system_parameters sys,

211: /* 13644150: Check for period open or future in GL */
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'