368: , p_ae_line_num
369: , ses.sid
370: , ses.serial#
371: , p_gl_date
372: FROM xla_subledgers xs
373: , gl_period_statuses gps
374: , v$session ses
375: WHERE xs.application_id = p_application_id
376: AND gps.application_id = 101
519: , ses.serial#
520: , xah.accounting_date
521: FROM xla_ae_headers xah
522: , xla_ae_lines xal
523: , xla_subledgers xs
524: , gl_period_statuses gps
525: , v$session ses
526: WHERE xal.application_id = xah.application_id
527: AND xal.ae_header_id = xah.ae_header_id