APPS.XLA_JELINES_RPT_PKG dependencies on GL_PERIOD_STATUSES

Line 320: AND glh.period_name IN ( select distinct Period_name from gl_period_statuses where

316: ,gl_ledgers glg
317: ,gl_periods glp
318: ,gl_code_combinations_kfv gcck
319: WHERE glg.ledger_id IN (:P_LEDGER_ID)
320: AND glh.period_name IN ( select distinct Period_name from gl_period_statuses where
321: ledger_id = :P_LEDGER_ID and period_num <
322: (select distinct Period_num from gl_period_statuses
323: where ledger_id = :P_LEDGER_ID and period_name = :P_PERIOD_FROM)
324: and period_year in

Line 322: (select distinct Period_num from gl_period_statuses

318: ,gl_code_combinations_kfv gcck
319: WHERE glg.ledger_id IN (:P_LEDGER_ID)
320: AND glh.period_name IN ( select distinct Period_name from gl_period_statuses where
321: ledger_id = :P_LEDGER_ID and period_num <
322: (select distinct Period_num from gl_period_statuses
323: where ledger_id = :P_LEDGER_ID and period_name = :P_PERIOD_FROM)
324: and period_year in
325: (select distinct Period_year from gl_period_statuses
326: where ledger_id = :P_LEDGER_ID and period_name = :P_PERIOD_FROM)

Line 325: (select distinct Period_year from gl_period_statuses

321: ledger_id = :P_LEDGER_ID and period_num <
322: (select distinct Period_num from gl_period_statuses
323: where ledger_id = :P_LEDGER_ID and period_name = :P_PERIOD_FROM)
324: and period_year in
325: (select distinct Period_year from gl_period_statuses
326: where ledger_id = :P_LEDGER_ID and period_name = :P_PERIOD_FROM)
327: )
328: AND glh.ledger_id = glg.ledger_id
329: AND gll.je_header_id = glh.je_header_id

Line 2011: ,gl_period_statuses glp --12609107

2007: ,xla_lookups xlk
2008: ,gl_lookups glk2
2009: ,gl_budget_versions gbv
2010: ,fnd_user fdu
2011: ,gl_period_statuses glp --12609107
2012: ,fun_seq_versions fsv1
2013: ,fun_seq_versions fsv2
2014: -- ,fnd_sequences fsq -- krsankar - Commented as part of Bug 7153425
2015: ,fnd_document_sequences fsq

Line 2532: FROM gl_period_statuses

2528: -- Getting effective period number for the from and to periods. Bug 12609107
2529: -----------------------------------------------------------------------------------
2530: SELECT period_year, effective_period_num
2531: INTO l_period_year, g_start_period_num
2532: FROM gl_period_statuses
2533: WHERE application_id = 101
2534: AND set_of_books_id = l_ledger_id
2535: AND period_name = p_period_from;
2536:

Line 2539: FROM gl_period_statuses

2535: AND period_name = p_period_from;
2536:
2537: SELECT effective_period_num
2538: INTO g_end_period_num
2539: FROM gl_period_statuses
2540: WHERE application_id = 101
2541: AND ledger_id = l_ledger_id
2542: AND period_name = p_period_to;
2543:

Line 2548: FROM gl_period_statuses

2544: SELECT TO_CHAR(MIN(start_date),'YYYY-MM-DD')
2545: ,TO_CHAR(MAX(end_date),'YYYY-MM-DD')
2546: INTO g_period_year_start_date
2547: ,g_period_year_end_date
2548: FROM gl_period_statuses
2549: WHERE application_id = 101
2550: AND set_of_books_id = l_ledger_id
2551: AND period_year = l_period_year
2552: AND adjustment_period_flag = 'N';