Rule Definition
Having an SQL query inside a loop is usually the source of performance and scalability problems especially if the number of iterations become very high (for example if it is dependent on the data returned from the database). This iterative pattern has proved to be very dangerous for application performance and scalability. Database servers handle in a much better set-oriented pattern rather than pure iterative ones.

Remediation
Try to reduce the number of opening cursors in the loops.

Violation Code Sample

[BEGIN of a LOOP (see what all type of loop are possible in Language Reference )]
open CAST_TEST
               with #sql{
  select A,B, C, D
   from CAST1_JOINT T1
    WHERE
       M = :N AND
                  ORDER BY
                    1 ASC
             WITH UR
     }
                into A, B, C, D
                for CAST2_JOINT;
[END of a LOOP (see what all type of loop are possible in Language Reference )]

Standard suggestions based on CAST Quality Model