APPS.GL_EXCH_RATES_SYNC_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 36

    SELECT pivot_currency,description
    FROM gl_cross_rate_rules
    WHERE conversion_type = l_conversion_type
    AND (pivot_currency = p_from_currency OR pivot_currency = p_to_currency);

Line: 43

    SELECT cr_cur_tbl.from_currency
    FROM
        (SELECT DISTINCT from_currency from_currency
        FROM gl_cross_rate_rule_dtls
        WHERE conversion_type = l_conversion_type
        AND enabled_flag = 'Y')cr_cur_tbl
    WHERE (cr_cur_tbl.from_currency = p_from_currency OR cr_cur_tbl.from_currency = p_to_currency);

Line: 53

    SELECT conversion_type
    FROM gl_daily_conversion_types
    WHERE user_conversion_type = p_conversion_rate_type;

Line: 63

    SELECT gldr.from_currency from_currency,
           gldr.to_currency to_currency,
           gldr.conversion_date conversion_date,
           gdct.user_conversion_type conversion_type,
           gldr.conversion_rate conversion_rate,
           1/conversion_rate inv_conv_rate,
           gldr.status_code status_code,
           gldr.rate_source_code rate_source_code,
           --decode(glcrs.pivot_currency,gldr.from_currency,gldr.from_currency,gldr.to_currency,gldr.to_currency,null) pivot_currency,
           null pivot_currency,
           --decode(glcrs.pivot_currency,gldr.from_currency,glcrs.description,gldr.to_currency,glcrs.description,null) description
           null description
    FROM gl_daily_rates gldr,
         gl_cross_rate_rules glcrs,
         gl_daily_conversion_types gdct
    WHERE gldr.conversion_date between c_from_date and c_to_date
    AND nvl2(c_conversion_rate_type,gldr.conversion_type,1) = nvl(c_conversion_rate_type,1)
    AND gldr.conversion_type = glcrs.conversion_type(+)
    AND gdct.conversion_type = gldr.conversion_type
    AND nvl2(c_from_currency,gldr.from_currency,1) = nvl(c_from_currency,1)
    AND nvl2(c_to_currency,gldr.to_currency,1) = nvl(c_to_currency,1);

Line: 92

    SELECT gldr.from_currency from_currency,
           gldr.to_currency to_currency,
           gldr.conversion_date conversion_date,
           gdct.user_conversion_type conversion_type,
           gldr.conversion_rate conversion_rate,
           1/conversion_rate inv_conv_rate,
           gldr.status_code status_code,
           gldr.rate_source_code rate_source_code,
           --decode(glcrs.pivot_currency,gldr.from_currency,gldr.from_currency,gldr.to_currency,gldr.to_currency,null) pivot_currency,
           l_pivot_currency pivot_currency,
           --decode(glcrs.pivot_currency,gldr.from_currency,glcrs.description,gldr.to_currency,glcrs.description,null) description
           l_description description
    FROM gl_daily_rates gldr,
         gl_cross_rate_rules glcrs,
         gl_daily_conversion_types gdct
    WHERE gldr.conversion_date between c_from_date and c_to_date
    AND nvl2(c_conversion_rate_type,gldr.conversion_type,1) = nvl(c_conversion_rate_type,1)
    AND gldr.conversion_type = glcrs.conversion_type
    AND gdct.conversion_type = gldr.conversion_type
    AND gldr.from_currency = c_contra_currency
    AND gldr.to_currency IN (SELECT DISTINCT from_currency
                             FROM gl_cross_rate_rule_dtls
                             WHERE nvl2(c_conversion_rate_type,conversion_type,1) = nvl(c_conversion_rate_type,1)
                             AND enabled_flag = 'Y');

Line: 124

   SELECT gldr.from_currency from_currency,
          gldr.to_currency to_currency,
          gldr.conversion_date conversion_date,
          gdct.user_conversion_type conversion_type,
          gldr.conversion_rate conversion_rate,
          1/conversion_rate inv_conv_rate,
          gldr.status_code status_code,
          gldr.rate_source_code rate_source_code,
          --decode(glcrs.pivot_currency,gldr.from_currency,gldr.from_currency,gldr.to_currency,gldr.to_currency,null) pivot_currency,
          l_pivot_currency pivot_currency,
          --decode(glcrs.pivot_currency,gldr.from_currency,glcrs.description,gldr.to_currency,glcrs.description,null) description
          l_description description
    FROM gl_daily_rates gldr,
         gl_cross_rate_rules glcrs,
         gl_daily_conversion_types gdct
    WHERE gldr.conversion_date between c_from_date and c_to_date
    AND nvl2(c_conversion_rate_type,gldr.conversion_type,1) = nvl(c_conversion_rate_type,1)
    AND gldr.conversion_type = glcrs.conversion_type
    AND gdct.conversion_type = gldr.conversion_type
    AND gldr.to_currency = c_contra_currency
    AND gldr.from_currency IN (SELECT DISTINCT from_currency
                               FROM gl_cross_rate_rule_dtls
                               WHERE nvl2(c_conversion_rate_type,conversion_type,1) = nvl(c_conversion_rate_type,1)
                               AND enabled_flag = 'Y');