APPS.PA_CI_TYPES_UTIL SQL Statements

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

Line: 12

  SELECT 'X'
  INTO l_temp
  FROM pa_ci_types_vl
  WHERE (name = p_name
         OR short_name = p_short_name)
    AND (p_ci_type_id IS NULL
         OR ci_type_id <> p_ci_type_id);

Line: 46

      SELECT ci_type_id
      INTO x_ci_type_id
      FROM pa_ci_types_b
      WHERE ci_type_id = p_ci_type_id
        AND l_sysdate BETWEEN TRUNC(start_date_active)
                          AND TRUNC(NVL(end_date_active, sysdate));

Line: 56

    SELECT ci_type_id
    INTO x_ci_type_id
    FROM pa_ci_types_vl
    WHERE name like p_name
      AND l_sysdate BETWEEN TRUNC(start_date_active)
                        AND TRUNC(NVL(end_date_active, sysdate));