DBA Data[Home] [Help]

APPS.XLA_PERIOD_CLOSE_EXP_PKG dependencies on GL_PERIOD_STATUSES

Line 409: FROM gl_period_statuses glp

405: END IF;
406:
407: SELECT start_date, end_date
408: INTO p_start_date, p_end_date
409: FROM gl_period_statuses glp
410: WHERE glp.period_name = p_period_from
411: AND glp.ledger_id = p_ledger_id
412: AND glp.adjustment_period_flag = 'N'
413: AND glp.application_id = gl_appl_id ;

Line 418: FROM gl_period_statuses glp

414:
415: IF p_period_from <> p_period_to THEN
416: SELECT end_date
417: INTO p_end_date
418: FROM gl_period_statuses glp
419: WHERE glp.period_name = p_period_to
420: AND glp.ledger_id = p_ledger_id
421: AND glp.adjustment_period_flag = 'N'
422: AND glp.application_id = gl_appl_id ;

Line 493: ,GL_PERIOD_STATUSES GPS

489: ' FROM XLA_EVENTS XLE
490: ,XLA_TRANSACTION_ENTITIES ENT
491: ,XLA_SUBLEDGERS XLS
492: ,FND_USER FNU
493: ,GL_PERIOD_STATUSES GPS
494: ,GL_LEDGERS GLD
495: ,GL_JE_SOURCES_TL GJT
496: ,GL_JE_CATEGORIES_TL GJCT
497: ,XLA_EVENT_CLASSES_TL XCL

Line 587: ,GL_PERIOD_STATUSES GPS

583: ,XLA_EVENTS XLE
584: ,XLA_TRANSACTION_ENTITIES ENT
585: ,XLA_SUBLEDGERS XLS
586: ,FND_USER FNU
587: ,GL_PERIOD_STATUSES GPS
588: ,GL_LEDGERS GLD
589: ,GL_JE_SOURCES_TL GJT
590: ,GL_JE_CATEGORIES_TL GJCT
591: ,XLA_EVENT_TYPES_B XET