DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_CAL_RLPS dependencies on FND_CURRENCIES

Line 3474: FROM FND_CURRENCIES) cur

3470: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
3471: null, 0.01,
3472: 0, 1,
3473: nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION)))) mau
3474: FROM FND_CURRENCIES) cur
3475: WHERE fact.CALENDAR_TYPE IN ('P', 'G')
3476: AND fact.worker_id = g_worker_id
3477: AND VER.worker_id = g_worker_id
3478: AND non_pa_cal.cal_period_id = fact.time_id

Line 3792: FROM FND_CURRENCIES) cur

3788: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
3789: null, 0.01,
3790: 0, 1,
3791: nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION)))) mau
3792: FROM FND_CURRENCIES) cur
3793: WHERE 1=1
3794: AND fact.CALENDAR_TYPE = 'A'
3795: AND fact.worker_id = g_worker_id
3796: AND ver.worker_id = g_worker_id

Line 4758: FROM FND_CURRENCIES) cur

4754: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
4755: null, 0.01,
4756: 0, 1,
4757: nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION)))) mau
4758: FROM FND_CURRENCIES) cur
4759: WHERE 1=1
4760: AND calDet.factor > 0
4761: AND fact.rbs_version_id = NVL(calDet.rbs_struct_version_id , -1)
4762: AND fact.CALENDAR_TYPE <> p_calendar_type

Line 5077: FROM FND_CURRENCIES) cur

5073: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
5074: null, 0.01,
5075: 0, 1,
5076: nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION)))) mau
5077: FROM FND_CURRENCIES) cur
5078: WHERE 1=1
5079: AND fact.CALENDAR_TYPE = 'A'
5080: AND fact.worker_id = g_worker_id
5081: AND ver.worker_id = g_worker_id