DBA Data[Home] [Help]

APPS.MSC_RESOURCE_PKG dependencies on FND_PROFILE

Line 243: t1.resource_cost * decode(t1.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) resource_cost2

239: to_number(null) order_quantity,
240: to_number(null) resource_hours,
241: to_number(null) no_of_orders,
242: t1.resource_cost,
243: t1.resource_cost * decode(t1.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) resource_cost2
244: from
245: /* For SNO plan don't filter detail_level.
246: */
247: (select

Line 278: where mcc.to_currency(+) = fnd_profile.value('MSC_HUB_CUR_CODE_RPT')

274: and mdr.organization_id = mdrs.organization_id
275: and mdr.department_id = mdrs.department_id
276: and mdr.resource_id = mdrs.resource_id) t1,
277: msc_currency_conv_mv mcc
278: where mcc.to_currency(+) = fnd_profile.value('MSC_HUB_CUR_CODE_RPT')
279: and mcc.from_currency(+) = nvl(t1.currency_code, 'XXX')
280: and mcc.calendar_date(+) = t1.resource_date
281:
282: )