4441: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
4442: null, 0.01,
4443: 0, 1,
4444: nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION)))) mau
4445: FROM FND_CURRENCIES) cur
4446: WHERE fact.CALENDAR_TYPE IN ('P', 'G')
4447: AND fact.worker_id = g_worker_id
4448: AND non_pa_cal.cal_period_id = fact.time_id
4449: AND fact.line_type like 'OF%'
7032: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
7033: null, 0.01,
7034: 0, 1,
7035: nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION)))) mau
7036: FROM FND_CURRENCIES) cur
7037: WHERE 1=1
7038: AND fact.CALENDAR_TYPE = 'A'
7039: AND fact.worker_id = g_worker_id
7040: AND fact.start_date IS NOT NULL
9529: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
9530: null, 0.01,
9531: 0, 1,
9532: nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION)))) mau
9533: FROM FND_CURRENCIES) cur
9534: WHERE 1=1
9535: AND calDet.factor > 0
9536: -- AND (calDet.rbs_struct_version_id = fact.rbs_version_id OR fact.rbs_version_id = -1)
9537: AND NVL(calDet.rbs_struct_version_id, -1) = fact.rbs_version_id
12139: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
12140: null, 0.01,
12141: 0, 1,
12142: nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION)))) mau
12143: FROM FND_CURRENCIES) cur
12144: WHERE 1=1
12145: AND fact.CALENDAR_TYPE = 'A'
12146: AND fact.worker_id = g_worker_id
12147: AND fact.start_date IS NOT NULL