DBA Data[Home] [Help]

APPS.PJI_PJP_PRG_PERF_ALL dependencies on FND_CURRENCIES

Line 1357: FROM FND_CURRENCIES) cur

1353: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
1354: null, 0.01,
1355: 0, 1,
1356: nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION)))) mau
1357: FROM FND_CURRENCIES) cur
1358: WHERE fact.CALENDAR_TYPE IN ('P', 'G')
1359: AND fact.worker_id = g_worker_id
1360: AND VER.worker_id = g_worker_id
1361: AND non_pa_cal.cal_period_id = fact.time_id

Line 1650: FROM FND_CURRENCIES) cur

1646: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
1647: null, 0.01,
1648: 0, 1,
1649: nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION)))) mau
1650: FROM FND_CURRENCIES) cur
1651: WHERE 1=1
1652: AND fact.CALENDAR_TYPE = 'A'
1653: AND fact.worker_id = g_worker_id
1654: AND ver.worker_id = g_worker_id

Line 1970: FROM FND_CURRENCIES) cur

1966: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
1967: null, 0.01,
1968: 0, 1,
1969: nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION)))) mau
1970: FROM FND_CURRENCIES) cur
1971: WHERE 1=1
1972: AND calDet.factor > 0
1973: AND fact.rbs_version_id = NVL(calDet.rbs_struct_version_id , -1)
1974: AND fact.CALENDAR_TYPE <> p_calendar_type

Line 2266: FROM FND_CURRENCIES) cur

2262: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
2263: null, 0.01,
2264: 0, 1,
2265: nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION)))) mau
2266: FROM FND_CURRENCIES) cur
2267: WHERE 1=1
2268: AND fact.CALENDAR_TYPE = 'A'
2269: AND fact.worker_id = g_worker_id
2270: AND ver.worker_id = g_worker_id