1479: WHEN OTHERS THEN
1480: p_old_pay_basis := '';
1481: END;
1482:
1483: p_old_to_new_currency_rate := hr_currency_pkg.get_rate_sql(
1484: p_from_currency => lv_tmp_currency,
1485: p_to_currency => lv_currency,
1486: p_conversion_date => p_effective_date,
1487: p_rate_type => hr_currency_pkg.get_rate_type (
1483: p_old_to_new_currency_rate := hr_currency_pkg.get_rate_sql(
1484: p_from_currency => lv_tmp_currency,
1485: p_to_currency => lv_currency,
1486: p_conversion_date => p_effective_date,
1487: p_rate_type => hr_currency_pkg.get_rate_type (
1488: p_business_group_id => ln_business_group_id,
1489: p_conversion_date => p_effective_date,
1490: p_processing_type => 'P'));
1491: