DBA Data[Home] [Help]

APPS.CE_AUTO_BANK_UNREC dependencies on GL_PERIOD_STATUSES

Line 197: FROM gl_period_statuses glp,

193: --IF (C_rec.org_id is not null or C_rec.legal_entity_id is not null) THEN
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

Line 215: FROM gl_period_statuses glp,

211:
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'