eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CE_AUTO_BANK_UNREC dependencies on CE_SYSTEM_PARAMETERS

Line 78: FROM CE_SYSTEM_PARAMETERS_ALL sys

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

Line 198: ce_system_parameters sys,

194: --IF (C_rec.bank_account_id is not null) THEN
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'

Line 216: ce_system_parameters sys

212: /*ELSE
213: SELECT count(1)
214: INTO l_count
215: FROM gl_period_statuses glp,
216: ce_system_parameters sys
217: WHERE glp.application_id = l_app_id
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');