APPS.ARRX_COGS_REP_INNER dependencies on FND_DATE

Line 233: (DECODE(sign(mmt.transaction_date -fnd_date.chardate_to_date(p_gl_date_low)), -1, 0, 1)

229: ROUND((SUM
230: (
231: DECODE
232: (
233: (DECODE(sign(mmt.transaction_date -fnd_date.chardate_to_date(p_gl_date_low)), -1, 0, 1)
234: +
235: DECODE(sign(mmt.transaction_date -fnd_date.chardate_to_date(p_gl_date_high)), 1, 0, 1)
236: ),
237: 2, arrx_cogs_rep_inner.get_cost(

Line 235: DECODE(sign(mmt.transaction_date -fnd_date.chardate_to_date(p_gl_date_high)), 1, 0, 1)

231: DECODE
232: (
233: (DECODE(sign(mmt.transaction_date -fnd_date.chardate_to_date(p_gl_date_low)), -1, 0, 1)
234: +
235: DECODE(sign(mmt.transaction_date -fnd_date.chardate_to_date(p_gl_date_high)), 1, 0, 1)
236: ),
237: 2, arrx_cogs_rep_inner.get_cost(
238: dist.account_class,
239: dist.rec_offset_flag,

Line 248: DECODE(sign(dist.gl_date - fnd_date.chardate_to_date(p_gl_date_low)), -1, 0, 1)

244: (
245: DECODE
246: (
247: (
248: DECODE(sign(dist.gl_date - fnd_date.chardate_to_date(p_gl_date_low)), -1, 0, 1)
249: +
250: DECODE(sign(dist.gl_date - fnd_date.chardate_to_date(p_gl_date_high)), 1, 0, 1)
251: ),
252: 2, DECODE(dist.account_class, 'UNEARN', 0, dist.acctd_amount), 0

Line 250: DECODE(sign(dist.gl_date - fnd_date.chardate_to_date(p_gl_date_high)), 1, 0, 1)

246: (
247: (
248: DECODE(sign(dist.gl_date - fnd_date.chardate_to_date(p_gl_date_low)), -1, 0, 1)
249: +
250: DECODE(sign(dist.gl_date - fnd_date.chardate_to_date(p_gl_date_high)), 1, 0, 1)
251: ),
252: 2, DECODE(dist.account_class, 'UNEARN', 0, dist.acctd_amount), 0
253: )
254: ))/count(DISTINCT mmt.transaction_id), l_precision) revenue