DBA Data[Home] [Help]

APPS.PV_CHECK_MATCH_PUB dependencies on AS_PERIOD_RATES

Line 1286: FROM as_period_rates rate,

1282: BEGIN
1283: SELECT round((p_amount/rate.denominator_rate) * rate.numerator_rate,2),
1284: rate.conversion_status_flag
1285: INTO l_converted_attr_value, l_conversion_status_flag
1286: FROM as_period_rates rate,
1287: as_period_days day
1288: WHERE rate.from_currency = p_currency_code AND
1289: rate.to_currency = p_rule_currency_code AND
1290: day.period_name = rate.period_name AND

Line 1582: FROM as_period_rates rate,

1578: BEGIN
1579: SELECT round((l_entity_attr_value/rate.denominator_rate) * rate.numerator_rate,2),
1580: rate.conversion_status_flag
1581: INTO l_converted_attr_value, l_conversion_status_flag
1582: FROM as_period_rates rate,
1583: as_period_days day
1584: WHERE rate.from_currency = l_entity_currency_code AND
1585: rate.to_currency = p_rule_currency_code AND
1586: day.period_name = rate.period_name AND