DBA Data[Home] [Help]

APPS.XLA_AE_HEADER_PKG dependencies on GL_TRANSACTION_DATES

Line 3250: FROM gl_transaction_dates d

3246: SET accounting_date =
3247: DECODE(xah.acc_rev_gl_date_option,
3248: 'XLA_NEXT_DAY',
3249: (SELECT min(transaction_date)
3250: FROM gl_transaction_dates d
3251: WHERE d.business_day_flag = 'Y'
3252: AND d.transaction_date >= xah.accounting_date
3253: AND d.transaction_calendar_id = l_transaction_calendar_id),
3254: -- XLA_FIRST_DAY_NEXT_GL_PERIOD, XLA_LAST_DAY_NEXT_GL_PERIOD, NONE

Line 3259: , gl_transaction_dates d

3255: (SELECT transaction_date
3256: FROM (SELECT xah2.ae_header_id
3257: , d.transaction_date
3258: FROM xla_ae_headers_gt xah2
3259: , gl_transaction_dates d
3260: WHERE d.transaction_calendar_id = l_transaction_calendar_id
3261: AND d.business_day_flag = 'Y'
3262: AND d.transaction_date >= xah2.period_start_date
3263: ORDER by CASE WHEN d.transaction_date = xah2.accounting_date