APPS.GL_DATE_HANDLER_PKG dependencies on GL_LEDGERS

Line 118: FROM gl_ledgers

114:
115: BEGIN
116: SELECT latest_encumbrance_year
117: INTO x_latest_year
118: FROM gl_ledgers
119: WHERE ledger_id = lgr_id;
120:
121: -- First, see if the non-adjusting period that contains this
122: -- date is within

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 314: FROM gl_ledgers

310:
311: -- Get the ledger information
312: SELECT period_set_name, transaction_calendar_id, accounted_period_type
313: INTO acct_cal_name, trans_cal_id, acc_period_type
314: FROM gl_ledgers
315: WHERE ledger_id = lgr_id;
316:
317: -- Determine the status of the period
318: BEGIN

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 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