eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GL_DATE_HANDLER_PKG dependencies on GL_JE_HEADERS

Line 201: FROM gl_je_headers jeh, gl_ledgers lgr

197: AND ps.end_date >= trunc(active_date)
198: AND ps.period_year <= one_latest_year
199: AND NOT EXISTS
200: (SELECT 'not open or future'
201: FROM gl_je_headers jeh, gl_ledgers lgr
202: WHERE jeh.je_batch_id = batch_id
203: AND lgr.ledger_id = jeh.ledger_id
204: AND nvl(lgr.latest_encumbrance_year,-1) < ps.period_year)
205: ORDER BY ps.effective_period_num ASC;

Line 210: FROM gl_je_headers jeh, gl_ledgers lgr

206:
207: BEGIN
208: SELECT lgr.ledger_id, lgr.latest_encumbrance_year
209: INTO one_ledger_id, one_latest_year
210: FROM gl_je_headers jeh, gl_ledgers lgr
211: WHERE jeh.je_batch_id = batch_id
212: AND lgr.ledger_id = jeh.ledger_id
213: AND rownum = 1;
214:

Line 231: FROM gl_je_headers jeh, gl_ledgers lgr

227: AND ps.period_name = map.period_name
228: AND ps.period_year <= one_latest_year
229: AND NOT EXISTS
230: (SELECT 'not open or future'
231: FROM gl_je_headers jeh, gl_ledgers lgr
232: WHERE jeh.je_batch_id = batch_id
233: AND lgr.ledger_id = jeh.ledger_id
234: AND nvl(lgr.latest_encumbrance_year,-1) < ps.period_year);
235:

Line 504: FROM gl_je_headers jeh, gl_period_statuses ps2

500: AND ps.effective_period_num >= min_eff_period_num
501: AND ps.closing_status IN ('O', 'F')
502: AND NOT EXISTS
503: (SELECT 'not open or future'
504: FROM gl_je_headers jeh, gl_period_statuses ps2
505: WHERE jeh.je_batch_id = batch_id
506: AND ps2.application_id = 101
507: AND ps2.ledger_id = jeh.ledger_id
508: AND ps2.period_name = ps.period_name

Line 517: FROM gl_je_headers jeh, gl_ledgers lgr

513: -- Get the ledger information
514: SELECT min(lgr.period_set_name), min(lgr.accounted_period_type),
515: min(lgr.transaction_calendar_id), min(lgr.ledger_id)
516: INTO acct_cal_name, acc_period_type, one_trans_cal_id, one_ledger_id
517: FROM gl_je_headers jeh, gl_ledgers lgr
518: WHERE jeh.je_batch_id = batch_id
519: AND lgr.ledger_id = jeh.ledger_id;
520:
521: -- Get information for one ledger and transaction calendar

Line 550: FROM gl_je_headers jeh, gl_period_statuses ps2

546: AND ps.effective_period_num >= min_eff_period_num
547: AND ps.closing_status IN ('O', 'F')
548: AND NOT EXISTS
549: (SELECT 'not open or future'
550: FROM gl_je_headers jeh, gl_period_statuses ps2
551: WHERE jeh.je_batch_id = batch_id
552: AND ps2.application_id = 101
553: AND ps2.ledger_id = jeh.ledger_id
554: AND ps2.period_name = ps.period_name

Line 580: FROM gl_je_headers jeh, gl_period_statuses ps2

576: AND ps.effective_period_num >= min_eff_period_num
577: AND ps.closing_status IN ('O', 'F')
578: AND NOT EXISTS
579: (SELECT 'not open or future'
580: FROM gl_je_headers jeh, gl_period_statuses ps2
581: WHERE jeh.je_batch_id = batch_id
582: AND ps2.application_id = 101
583: AND ps2.ledger_id = jeh.ledger_id
584: AND ps2.period_name = ps.period_name

Line 624: FROM gl_je_headers jeh, gl_ledgers lgr

620: roll_dates := 'N';
621:
622: SELECT nvl(max('Y'),'N')
623: INTO roll_dates
624: FROM gl_je_headers jeh, gl_ledgers lgr
625: WHERE jeh.je_batch_id = batch_id
626: AND lgr.ledger_id = jeh.ledger_id
627: AND lgr.enable_average_balances_flag = 'Y'
628: AND lgr.consolidation_ledger_flag = 'N'

Line 644: FROM gl_je_headers jeh, gl_ledgers lgr

640: INTO business_day
641: FROM gl_transaction_dates
642: WHERE transaction_calendar_id
643: IN (SELECT transaction_calendar_id
644: FROM gl_je_headers jeh, gl_ledgers lgr
645: WHERE jeh.je_batch_id = batch_id
646: AND lgr.ledger_id = jeh.ledger_id)
647: AND transaction_date = initial_accounting_date;
648:

Line 675: FROM gl_je_headers jeh, gl_ledgers lgr,

671: AND trans.business_day_flag = 'Y'
672: AND trans.transaction_date < initial_accounting_date
673: AND NOT EXISTS
674: (SELECT 'not business'
675: FROM gl_je_headers jeh, gl_ledgers lgr,
676: gl_transaction_dates trans2
677: WHERE jeh.je_batch_id = batch_id
678: AND lgr.ledger_id = jeh.ledger_id
679: AND trans2.transaction_calendar_id

Line 704: FROM gl_je_headers jeh, gl_ledgers lgr,

700: AND trans.business_day_flag = 'Y'
701: AND trans.transaction_date > initial_accounting_date
702: AND NOT EXISTS
703: (SELECT 'not business'
704: FROM gl_je_headers jeh, gl_ledgers lgr,
705: gl_transaction_dates trans2
706: WHERE jeh.je_batch_id = batch_id
707: AND lgr.ledger_id = jeh.ledger_id
708: AND trans2.transaction_calendar_id