APPS.CE_JE_CREATION dependencies on GL_PERIOD_STATUSES

Line 159: FROM gl_period_statuses glp,

155: BEGIN
156: log('>>valid_accounting_date');
157: SELECT count(*)
158: INTO l_count
159: FROM gl_period_statuses glp,
160: ce_system_parameters sys
161: WHERE glp.set_of_books_id = sys.set_of_books_id
162: AND sys.legal_entity_id = CE_JE_CREATION.ba_legal_entity_id
163: AND glp.closing_status in ('O','F')

Line 237: FROM gl_period_statuses glp,

233: -- 12953296: Find the next open period after the trx date
234: ELSE
235: SELECT MIN(glp.start_date)
236: INTO CE_JE_CREATION.cf_cleared_date
237: FROM gl_period_statuses glp,
238: ce_system_parameters SYS
239: WHERE glp.set_of_books_id = sys.set_of_books_id
240: AND sys.legal_entity_id = CE_JE_CREATION.ba_legal_entity_id /*13114107 fixed*/
241: AND glp.closing_status IN ('O','F')