DBA Data[Home] [Help]

APPS.XLA_ACCT_ANALYSIS_RPT_PKG dependencies on GL_PERIOD_STATUSES

Line 675: FROM gl_period_statuses

671: SELECT effective_period_num
672: ,START_DATE
673: INTO l_start_period_num
674: ,l_start_date
675: FROM gl_period_statuses
676: WHERE application_id = 101
677: AND ledger_id = l_ledger_id
678: AND period_name = p_period_from;
679:

Line 684: FROM gl_period_statuses

680: SELECT effective_period_num
681: ,end_date
682: INTO l_end_period_num
683: ,l_end_date
684: FROM gl_period_statuses
685: WHERE application_id = 101
686: AND ledger_id = l_ledger_id
687: AND period_name = p_period_to;
688:

Line 2141: ,gl_period_statuses gls

2137: ,gls.period_name
2138: ,gls.start_date
2139: ,gls.end_date
2140: FROM gl_ledgers gll
2141: ,gl_period_statuses gls
2142: WHERE gls.ledger_id = gll.ledger_id
2143: AND gls.application_id = 101
2144: AND gls.effective_period_num BETWEEN :P_START_PERIOD_NUM AND :P_END_PERIOD_NUM
2145: AND gll.ledger_id IN $ledger_id$