DBA Data[Home] [Help]

APPS.PV_CHECK_MATCH_PUB dependencies on AS_PERIOD_DAYS

Line 1287: as_period_days day

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
1291: day.period_set_name = g_period_set_name AND

Line 1583: as_period_days day

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
1587: day.period_set_name = g_period_set_name AND