DBA Data[Home] [Help]

APPS.AS_SC_DENORM_TRG dependencies on AS_PERIOD_RATES

Line 62: From as_period_rates pr, as_period_days pd

58: p_status_flg OUT NOCOPY Number) IS
59:
60: Cursor factor (p_currency IN Varchar2, p_date IN Date) IS
61: Select denominator_rate, numerator_rate, minimum_accountable_unit, conversion_status_flag
62: From as_period_rates pr, as_period_days pd
63: Where pr.from_currency = p_currency
64: and pr.to_currency = FND_PROFILE.VALUE('AS_PREFERRED_CURRENCY')
65: and pr.conversion_type = FND_PROFILE.VALUE('AS_MC_DAILY_CONVERSION_TYPE')
66: and pr.conversion_status_flag = 0