DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_CAL_RLPS_T dependencies on FND_CURRENCIES

Line 4583: FROM FND_CURRENCIES) cur

4579: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
4580: null, 0.01,
4581: 0, 1,
4582: nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION)))) mau
4583: FROM FND_CURRENCIES) cur
4584: WHERE fact.CALENDAR_TYPE IN ('P', 'G')
4585: AND fact.worker_id = g_worker_id
4586: AND non_pa_cal.cal_period_id = fact.time_id
4587: AND fact.line_type like 'OF%'

Line 7174: FROM FND_CURRENCIES) cur

7170: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
7171: null, 0.01,
7172: 0, 1,
7173: nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION)))) mau
7174: FROM FND_CURRENCIES) cur
7175: WHERE 1=1
7176: AND fact.CALENDAR_TYPE = 'A'
7177: AND fact.worker_id = g_worker_id
7178: AND fact.start_date IS NOT NULL

Line 9671: FROM FND_CURRENCIES) cur

9667: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
9668: null, 0.01,
9669: 0, 1,
9670: nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION)))) mau
9671: FROM FND_CURRENCIES) cur
9672: WHERE 1=1
9673: AND calDet.factor > 0
9674: -- AND (calDet.rbs_struct_version_id = fact.rbs_version_id OR fact.rbs_version_id = -1)
9675: AND NVL(calDet.rbs_struct_version_id, -1) = fact.rbs_version_id

Line 12281: FROM FND_CURRENCIES) cur

12277: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
12278: null, 0.01,
12279: 0, 1,
12280: nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION)))) mau
12281: FROM FND_CURRENCIES) cur
12282: WHERE 1=1
12283: AND fact.CALENDAR_TYPE = 'A'
12284: AND fact.worker_id = g_worker_id
12285: AND fact.start_date IS NOT NULL