DBA Data[Home] [Help]

APPS.ISC_DBI_MSC_OBJECTS_C dependencies on FII_CURRENCY

Line 962: fii_currency.get_global_rate_primary(gsb.currency_code, g_snapshot_date) RATE,

958: RATE2)
959: SELECT org.organization_id ORGANIZATION_ID,
960: gsb.currency_code FROM_CURRENCY,
961: g_snapshot_date CONVERSION_DATE,
962: fii_currency.get_global_rate_primary(gsb.currency_code, g_snapshot_date) RATE,
963: fii_currency.get_global_rate_secondary(gsb.currency_code, g_snapshot_date) RATE2
964: FROM (SELECT distinct organization_id
965: FROM isc_dbi_plan_organizations ido,
966: isc_dbi_tmp_plans tmp

Line 963: fii_currency.get_global_rate_secondary(gsb.currency_code, g_snapshot_date) RATE2

959: SELECT org.organization_id ORGANIZATION_ID,
960: gsb.currency_code FROM_CURRENCY,
961: g_snapshot_date CONVERSION_DATE,
962: fii_currency.get_global_rate_primary(gsb.currency_code, g_snapshot_date) RATE,
963: fii_currency.get_global_rate_secondary(gsb.currency_code, g_snapshot_date) RATE2
964: FROM (SELECT distinct organization_id
965: FROM isc_dbi_plan_organizations ido,
966: isc_dbi_tmp_plans tmp
967: WHERE bitand(tmp.plan_usage, 2) = 2