APPS.PA_IND_COST_CODES_PKG SQL Statements

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

Line: 30

    SELECT  count(1)
      INTO  dummy
      FROM  dual
     WHERE EXISTS
            ( SELECT  1
                FROM  pa_cost_base_cost_codes
               WHERE  ind_cost_code = X_icc_name );

Line: 42

      SELECT  count(1)
        INTO  dummy
        FROM  dual
       WHERE EXISTS
              ( SELECT  1
                  FROM  pa_ind_cost_multipliers
                 WHERE  ind_cost_code = X_icc_name );

Line: 57

        SELECT  count(1)
          INTO  dummy
          FROM  dual
         WHERE EXISTS
                ( SELECT  1
                    FROM  pa_compiled_multipliers
                   WHERE  ind_cost_code = X_icc_name );

Line: 100

    SELECT 1
      INTO dummy
      FROM dual
     WHERE NOT EXISTS
            ( SELECT 1
                FROM pa_ind_cost_codes
               WHERE ind_cost_code = X_icc_name
                 AND  (   ( X_rowid IS NULL )
                       OR ( rowid <> X_rowid ) ) );