DBA Data[Home] [Help]

APPS.QPR_SR_UTIL dependencies on QPR_CURRENCY_RATES

Line 854: from qpr_currency_rates

850: cursor c_is_there_fixed_rate is
851: select from_currency,
852: to_currency,
853: conversion_rate
854: from qpr_currency_rates
855: where from_currency in (p_from_currency, p_to_currency)
856: and conversion_date <= p_conversion_date
857: and conversion_class = 'FIXED'
858: and instance_id = p_instance_id;

Line 944: from qpr_currency_rates

940: l_rate := 1;
941: else
942: -- Get conversion rate between the two currencies from GL_DAILY_RATES
943: select conversion_rate into l_rate
944: from qpr_currency_rates
945: where instance_id = p_instance_id
946: and conversion_class = 'DAILY'
947: and from_currency = s_from_currency
948: and to_currency = s_to_currency