DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_CAL_RLPS dependencies on FND_CURRENCIES

Line 3227: FROM FND_CURRENCIES) cur

3223: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
3224: null, 0.01,
3225: 0, 1,
3226: nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION)))) mau
3227: FROM FND_CURRENCIES) cur
3228: WHERE fact.CALENDAR_TYPE IN ('P', 'G')
3229: AND fact.worker_id = g_worker_id
3230: AND VER.worker_id = g_worker_id
3231: AND non_pa_cal.cal_period_id = fact.time_id

Line 3536: FROM FND_CURRENCIES) cur

3532: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
3533: null, 0.01,
3534: 0, 1,
3535: nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION)))) mau
3536: FROM FND_CURRENCIES) cur
3537: WHERE 1=1
3538: AND fact.CALENDAR_TYPE = 'A'
3539: AND fact.worker_id = g_worker_id
3540: AND ver.worker_id = g_worker_id

Line 4493: FROM FND_CURRENCIES) cur

4489: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
4490: null, 0.01,
4491: 0, 1,
4492: nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION)))) mau
4493: FROM FND_CURRENCIES) cur
4494: WHERE 1=1
4495: AND calDet.factor > 0
4496: AND fact.rbs_version_id = NVL(calDet.rbs_struct_version_id , -1)
4497: AND fact.CALENDAR_TYPE <> p_calendar_type

Line 4804: FROM FND_CURRENCIES) cur

4800: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
4801: null, 0.01,
4802: 0, 1,
4803: nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION)))) mau
4804: FROM FND_CURRENCIES) cur
4805: WHERE 1=1
4806: AND fact.CALENDAR_TYPE = 'A'
4807: AND fact.worker_id = g_worker_id
4808: AND ver.worker_id = g_worker_id