APPS.QPR_SR_UTIL dependencies on FND_CURRENCIES

Line 809: -- Get currency information from FND_CURRENCIES table

805: p_conversion_rate in out nocopy number,
806: p_mau in out nocopy number,
807: p_currency_type in out nocopy varchar2 ) is
808: begin
809: -- Get currency information from FND_CURRENCIES table
810: select decode( derive_type,
811: 'EURO', 'EURO',
812: 'EMU', decode( sign(trunc(p_eff_date) - trunc(derive_effective)),
813: -1, 'OTHER','EMU'),

Line 821: from FND_CURRENCIES

817: 'EMU', derive_factor,
818: 'OTHER', -1 ),
819: nvl( minimum_accountable_unit, power( 10, (-1 * precision)))
820: into p_currency_type, p_conversion_rate, p_mau
821: from FND_CURRENCIES
822: where currency_code = p_currency;
823: exception
824: when NO_DATA_FOUND then
825: raise INVALID_CURRENCY;

Line 833: from FND_CURRENCIES

829: s_euro_code varchar2(20);
830: begin
831: -- Get currency code of the EURO currency
832: select currency_code into s_euro_code
833: from FND_CURRENCIES
834: where derive_type = 'EURO';
835:
836: return( s_euro_code );
837: exception

Line 878: | EURO -> FRENCH FRANK fixed rate from the FND_CURRENCIES |

874: | |
875: | 1) Old Currency to French Franks |
876: | Old Currency -> New Currency from the GL_FIXED_CONV_RATES table |
877: | New Currency -> EURO from the GL_DAILY_RATES |
878: | EURO -> FRENCH FRANK fixed rate from the FND_CURRENCIES |
879: | |
880: | 2) USD to New Currency |
881: | USD -> New CURRENCY from the GL Daily Rates Table. |
882: | |