APPS.POA_CM_EVALUATION_ICX SQL Statements

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

Line: 97

    select
      nvl(poa_cm_evaluated_by_id, user_id),
      nvl(poa_cm_evaluated_by, user_name)
    into
      l_employee_id,
      l_emp_name
    from
      fnd_user
    where
      user_id = l_user_id;

Line: 108

    select
      nvl(poa_cm_custom_measure_code, lookup_code),
      nvl(poa_cm_custom_measure, displayed_field)
    into
     l_cm_code,
     l_custom_measure
    from
      po_lookup_codes
    where
      lookup_type = 'CUSTOM MEASURE' and
      lookup_code = 'CUSTOMER SATISFACTION';

Line: 120

    select nvl(poa_cm_period_type, t.period_type),
           nvl(poa_cm_user_period_type, t.user_period_type),
           nvl(poa_cm_period_name, p.period_name)
      into l_period_type,
           l_user_period_type,
           l_period_name
      from gl_periods p,
           gl_period_types t,
           financials_system_parameters f,
           gl_sets_of_books b
     where f.set_of_books_id = b.set_of_books_id
       and b.accounted_period_type = p.period_type
       and b.period_set_name = p.period_set_name
       and p.period_type = t.period_type
       and trunc(sysdate) >= trunc(p.start_date)
       and trunc(sysdate) <= trunc(p.end_date);

Line: 143

     select nvl(poa_cm_operating_unit, name)
       into l_operating_unit
       from hr_operating_units
      where organization_id = l_org_id;

Line: 153

       select decode(l_operating_unit, name, l_org_id, nvl(poa_cm_oper_unit_id, to_number(NULL)))
       into l_oper_unit_id
       from hr_operating_units
       where organization_id = l_org_id;

Line: 182

  if (submit_type == "Update")
    f.POA_CM_SUBMIT_TYPE.value = "Update";

Line: 223

          c_js_where_clause = " ORG_ID in (select ORG_ID  from POA_CM_SITE_LOV_V where " +
                              " VENDOR_ID = " + f.POA_CM_SUPPLIER_ID.value.replace(/''/g,"''''") + " AND " +
                              " VENDOR_SITE_ID = " + f.POA_CM_SUPPLIER_SITE_ID.value.replace(/''/g,"''''") + ")";

Line: 227

          c_js_where_clause = " ORG_ID in (select ORG_ID  from POA_CM_SITE_LOV_V where " +
                              " VENDOR_NAME = ''" + f.POA_CM_SUPPLIER.value.replace(/''/g,"''''") + "'' AND " +
                              " VENDOR_SITE_ID = " + f.POA_CM_SUPPLIER_SITE_ID.value.replace(/''/g,"''''") + ")";

Line: 232

          c_js_where_clause = " ORG_ID in (select ORG_ID  from POA_CM_SITE_LOV_V where " +
                              " VENDOR_ID = " + f.POA_CM_SUPPLIER_ID.value.replace(/''/g,"''''") + " AND " +
                              " VENDOR_SITE_CODE = ''" + f.POA_CM_SUPPLIER_SITE.value.replace(/''/g,"''''") + "'')";

Line: 236

          c_js_where_clause = " ORG_ID in (select ORG_ID  from POA_CM_SITE_LOV_V where " +
                              " VENDOR_NAME = ''" + f.POA_CM_SUPPLIER.value.replace(/''/g,"''''") + "'' AND " +
                              " VENDOR_SITE_CODE = ''" + f.POA_CM_SUPPLIER_SITE.value.replace(/''/g,"''''") + "'')";

Line: 245

        c_js_where_clause = " ORGANIZATION_ID in (select INVENTORY_ORGANIZATION_ID from FINANCIALS_SYSTEM_PARAMETERS)" +
                            " AND CATEGORY_ID = " + f.POA_CM_CATEGORY_ID.value.replace(/''/g,"''''");

Line: 248

        c_js_where_clause = " ORGANIZATION_ID in (select INVENTORY_ORGANIZATION_ID from FINANCIALS_SYSTEM_PARAMETERS)" +
                            " AND COMMODITY = ''" + f.POA_CM_COMMODITY.value.replace(/''/g,"''''") + "''";

Line: 251

      c_js_where_clause = " ORGANIZATION_ID in (select INVENTORY_ORGANIZATION_ID from FINANCIALS_SYSTEM_PARAMETERS)";

Line: 618

    g_attribute_table.DELETE;

Line: 790