DBA Data[Home] [Help]

APPS.XLA_DRILLDOWN_PKG dependencies on DUAL

Line 326: SELECT count(*) into l_count FROM dual

322:
323: --7674572 Get the count only if the je_source is payables.
324: IF(p_je_source = 'Payables') THEN
325:
326: SELECT count(*) into l_count FROM dual
327: where exists (select 1 from xla_ae_lines ael,gl_import_references gir
328: where ael.gl_sl_link_id = gir.gl_sl_link_id
329: and ael.gl_sl_link_table = gir.gl_sl_link_table
330: and gir.je_header_id = p_je_header_id