DBA Data[Home] [Help]

APPS.XLA_PERIOD_CLOSE_EXP_PKG dependencies on GL_PERIOD_STATUSES

Line 415: FROM gl_period_statuses glp

411: END IF;
412:
413: SELECT start_date, end_date
414: INTO p_start_date, p_end_date
415: FROM gl_period_statuses glp
416: WHERE glp.period_name = p_period_from
417: AND glp.ledger_id = p_ledger_id
418: AND glp.adjustment_period_flag = 'N'
419: AND glp.application_id = gl_appl_id ;

Line 424: FROM gl_period_statuses glp

420:
421: IF p_period_from <> p_period_to THEN
422: SELECT end_date
423: INTO p_end_date
424: FROM gl_period_statuses glp
425: WHERE glp.period_name = p_period_to
426: AND glp.ledger_id = p_ledger_id
427: AND glp.adjustment_period_flag = 'N'
428: AND glp.application_id = gl_appl_id ;

Line 499: ,GL_PERIOD_STATUSES GPS

495: ' FROM XLA_EVENTS XLE
496: ,XLA_TRANSACTION_ENTITIES ENT
497: ,XLA_SUBLEDGERS XLS
498: ,FND_USER FNU
499: ,GL_PERIOD_STATUSES GPS
500: ,GL_LEDGERS GLD
501: ,GL_JE_SOURCES_TL GJT
502: ,GL_JE_CATEGORIES_TL GJCT
503: ,XLA_EVENT_CLASSES_TL XCL

Line 594: ,GL_PERIOD_STATUSES GPS

590: ,XLA_EVENTS XLE
591: ,XLA_TRANSACTION_ENTITIES ENT
592: ,XLA_SUBLEDGERS XLS
593: ,FND_USER FNU
594: ,GL_PERIOD_STATUSES GPS
595: ,GL_LEDGERS GLD
596: ,GL_JE_SOURCES_TL GJT
597: ,GL_JE_CATEGORIES_TL GJCT
598: ,XLA_EVENT_TYPES_B XET