DBA Data[Home] [Help]

APPS.XLA_JE_FUNDS_CHECKER_PKG dependencies on V$SESSION

Line 374: , v$session ses

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
377: AND gps.ledger_id = p_ledger_id
378: AND p_gl_date between gps.start_date and gps.end_date

Line 525: , v$session ses

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
528: AND xs.application_id = xah.application_id
529: AND gps.application_id = 101