DBA Data[Home] [Help]

APPS.XLA_TB_DATA_MANAGER_PVT dependencies on FND_DATE

Line 4181: >= fnd_date.canonical_to_date(g_gl_date_from)

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: )

Line 4183: <= fnd_date.canonical_to_date(g_gl_date_to)

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

Line 4229: >= fnd_date.canonical_to_date(g_gl_date_from)

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: )

Line 4231: <= fnd_date.canonical_to_date(g_gl_date_to)

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;