APPS.OKI_DBI_CURRENCY_PVT SQL Statements

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

Line: 87

       SELECT TO_NUMBER(DECODE(okc_currency_api.get_currency_type(
                                       p_func_curr_code
                                     , to_date(rul.rule_information2
                                                ,'YYYY/MM/DD HH24:MI:SS'))
                               , 'EMU',rul.rule_information3
                               , rul.rule_information1)
                           ) trx_func_rate
              , TO_DATE(rul.rule_information2, 'YYYY/MM/DD HH24:MI:SS') conversion_date
              , rul.object1_id1 conversion_type
           INTO   l_trx_func_rate
                , l_conversion_date
                , l_conversion_type
           FROM okc_rules_b rul,
                okc_rule_groups_b rgp
           WHERE rul.rule_information_category = 'CVN'
           AND rul.rgp_id     = rgp.id
           AND rgp.dnz_chr_id = p_chr_id ;

Line: 107

 /*   select
		       h.conversion_rate trx_func_rate
              ,h.conversion_rate_date conversion_date
              , h.conversion_type
      INTO   l_trx_func_rate
                , l_conversion_date
                , l_conversion_type
      from okc_k_headers_b h
      where h.id = p_chr_id
      AND h.template_yn       = 'N'
      AND h.application_id    = 515
      AND h.scs_code IN ('SERVICE','WARRANTY');