APPS.JAI_CMN_UTILS_PKG dependencies on GL_DAILY_RATES

Line 456: FROM Gl_Daily_Rates

452: /*Commented use of cursor bug mmurtua for bug 16456183*/
453: /*CURSOR get_curr_rate(p_to_curr IN varchar2,
454: p_from_curr IN varchar2) IS
455: SELECT Conversion_Rate
456: FROM Gl_Daily_Rates
457: WHERE To_Currency = p_to_curr
458: and From_Currency = p_from_curr
459: and trunc(Conversion_Date) = trunc(nvl(c_conversion_date,sysdate))
460: and Conversion_Type = c_conversion_type;*/

Line 489: FROM Gl_Daily_Rates

485: FETCH get_curr_rate INTO ret_value;
486: CLOSE get_curr_rate;*/
487:
488: SELECT Conversion_Rate INTO ret_value
489: FROM Gl_Daily_Rates
490: WHERE To_Currency = v_func_curr
491: and From_Currency = v_frm_curr
492: and trunc(Conversion_Date) = trunc(nvl(c_conversion_date,sysdate))
493: and Conversion_Type = c_conversion_type;

Line 521: FROM Gl_Daily_Rates

517: FETCH get_curr_rate INTO ret_value;
518: CLOSE get_curr_rate;*/
519:
520: SELECT Conversion_Rate INTO ret_value
521: FROM Gl_Daily_Rates
522: WHERE To_Currency = v_func_curr
523: and From_Currency = v_frm_curr
524: and trunc(Conversion_Date) = trunc(nvl(c_conversion_date,sysdate))
525: and Conversion_Type = c_conversion_type;