Insert script with multiple cursors and condition check

DECLARE
CURSOR C1
IS
  SELECT ID FROM TABLE_NAME_1 WHERE COLUMN IN ('');
  CURSOR C2
    IS
      SELECT ID FROM TABLE_NAME_2 WHERE COLUMN IN ('');
     
       CURSOR C3 (CP_TABLE_01_ID NUMBER,CP_TABLE_02_ID NUMBER)
        IS
          SELECT COUNT(*) AS COUNT_UP
          FROM TABLE_NAME_3
          WHERE COLUMN_CONDITION_01=CP_TABLE_02_ID
          AND COLUMN_CONDITION_02=CP_TABLE_01_ID;
COUNT_UP NUMBER;
BEGIN
FOR R1 IN C1
LOOP
    FOR R2 IN C2
    LOOP
 
       OPEN C3(R1.ID,R2.ID);
       FETCH C3 INTO COUNT_UP;
       CLOSE C3;
     
        IF (COUNT_UP=0) THEN
          INSERT
          INTO TABLE_NAME_3
            (
              ID,
              COLUMN_01,
              COLUMN_02
            )
            VALUES
            (
              VALUES
            );
        END IF;
    END LOOP;

END LOOP;
END;