4177: AND xjs.je_source_name = xsu.je_source_name
4178: AND xsu.je_source_name = g_je_source_name
4179: AND aeh.application_id = xsu.application_id
4180: AND aeh.accounting_date
4181: >= fnd_date.canonical_to_date(g_gl_date_from)
4182: AND aeh.accounting_date
4183: <= fnd_date.canonical_to_date(g_gl_date_to)
4184: GROUP BY ae_header_id
4185: )
4179: AND aeh.application_id = xsu.application_id
4180: AND aeh.accounting_date
4181: >= fnd_date.canonical_to_date(g_gl_date_from)
4182: AND aeh.accounting_date
4183: <= fnd_date.canonical_to_date(g_gl_date_to)
4184: GROUP BY ae_header_id
4185: )
4186: GROUP BY wu;
4187: ELSE
4225: AND xjs.je_source_name = xsu.je_source_name
4226: AND xsu.je_source_name = g_je_source_name
4227: AND aeh.application_id = xsu.application_id
4228: AND aeh.accounting_date
4229: >= fnd_date.canonical_to_date(g_gl_date_from)
4230: AND aeh.accounting_date
4231: <= fnd_date.canonical_to_date(g_gl_date_to)
4232: GROUP BY ae_header_id
4233: )
4227: AND aeh.application_id = xsu.application_id
4228: AND aeh.accounting_date
4229: >= fnd_date.canonical_to_date(g_gl_date_from)
4230: AND aeh.accounting_date
4231: <= fnd_date.canonical_to_date(g_gl_date_to)
4232: GROUP BY ae_header_id
4233: )
4234: GROUP BY wu;
4235: END IF;