DBA Data[Home] [Help]

APPS.CE_AUTO_BANK_UNREC dependencies on GL_PERIOD_STATUSES

Line 195: FROM gl_period_statuses glp,

191: THEN
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

Line 214: FROM gl_period_statuses glp,

210:
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