DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_CAL_RLPS_T dependencies on FND_CURRENCIES

Line 4445: FROM FND_CURRENCIES) cur

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%'

Line 7036: FROM FND_CURRENCIES) cur

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

Line 9533: FROM FND_CURRENCIES) cur

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

Line 12143: FROM FND_CURRENCIES) cur

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