APPS.CN_COLLECTION_AIA_OM_PUB SQL Statements

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

Line: 31

      SELECT salesrep_number
      FROM jtf_rs_salesreps
      WHERE salesrep_id = p_salesrep_id
       AND org_id = p_org_id;

Line: 67

         SELECT conversion_date
           FROM gl_daily_rates
          WHERE from_currency 	= p_from_currency
            AND to_currency	= l_to_currency
            AND conversion_type	= l_conversion_type
            AND conversion_date	= p_conversion_date
            AND rownum		< 2
          ORDER BY conversion_date DESC;

Line: 77

         SELECT MAX(conversion_date) conversion_date
           FROM gl_daily_rates
          WHERE from_currency 	= p_from_currency
            AND to_currency	= l_to_currency
            AND conversion_type	= l_conversion_type
            AND conversion_date	< p_conversion_date;

Line: 151

    SELECT DISTINCT salesrep_id,
         amt_curcy_cd,processed_date, revenue_type
    FROM cn_aia_order_capture
    WHERE
       preprocess_flag = fnd_api.g_false AND
       org_id = p_org_id
       AND update_flag = 'N';

Line: 188

        UPDATE cn_aia_order_capture
        SET employee_number = l_employee_num,
            exchange_rate = l_exchange_rate,
            revenue_type = l_revenue_type,
            adjust_status = 'MANUAL',
            --preprocess_flag = fnd_api.g_false,
            update_flag = 'Y'
        WHERE (salesrep_id = salesreps_tbl(indx).salesrep_id)
         AND amt_curcy_cd = salesreps_tbl(indx).amt_curcy_cd
         AND processed_date = salesreps_tbl(indx).processed_date
         AND nvl(revenue_type, 'REVENUE') =   nvl(salesreps_tbl(indx).revenue_type, 'REVENUE')
         AND update_flag = 'N'
         AND preprocess_flag = fnd_api.g_false
         AND org_id = p_org_id;