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_TRANSACTION_DATES

Line 399: FROM gl_transaction_dates

395: -- Determine if the day is a business day
396: BEGIN
397: SELECT business_day_flag
398: INTO business_day
399: FROM gl_transaction_dates
400: WHERE transaction_calendar_id = trans_cal_id
401: AND transaction_date = initial_accounting_date;
402:
403: IF (business_day = 'Y') THEN

Line 420: FROM gl_transaction_dates trans

416: -- Roll the date back to a business day
417: BEGIN
418: SELECT max(transaction_date)
419: INTO new_accounting_date
420: FROM gl_transaction_dates trans
421: WHERE trans.transaction_calendar_id = trans_cal_id
422: AND trans.transaction_date >= greatest(period_start_date,
423: nvl(minimum_date,
424: period_start_date))

Line 441: FROM gl_transaction_dates trans

437: -- Roll the date forward to a business day
438: BEGIN
439: SELECT min(transaction_date)
440: INTO new_accounting_date
441: FROM gl_transaction_dates trans
442: WHERE trans.transaction_calendar_id = trans_cal_id
443: AND trans.transaction_date <= period_end_date
444: AND trans.business_day_flag = 'Y'
445: AND trans.transaction_date > initial_accounting_date;

Line 641: FROM gl_transaction_dates

637: -- Determine if the day is a business day
638: BEGIN
639: SELECT decode(min(decode(business_day_flag, 'Y', 1, 0)),1, 'Y', 'N')
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

Line 666: FROM gl_transaction_dates trans

662: -- Roll the date back to a business day
663: BEGIN
664: SELECT max(transaction_date)
665: INTO new_accounting_date
666: FROM gl_transaction_dates trans
667: WHERE trans.transaction_calendar_id = one_trans_cal_id
668: AND trans.transaction_date >= greatest(period_start_date,
669: nvl(minimum_date,
670: period_start_date))

Line 676: gl_transaction_dates trans2

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
680: = lgr.transaction_calendar_id

Line 697: FROM gl_transaction_dates trans

693: -- Roll the date forward to a business day
694: BEGIN
695: SELECT min(transaction_date)
696: INTO new_accounting_date
697: FROM gl_transaction_dates trans
698: WHERE trans.transaction_calendar_id = one_trans_cal_id
699: AND trans.transaction_date <= period_end_date
700: AND trans.business_day_flag = 'Y'
701: AND trans.transaction_date > initial_accounting_date

Line 705: gl_transaction_dates trans2

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
709: = lgr.transaction_calendar_id