Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
create table service(
DIV CHAR(4 BYTE),
PAID    CHAR(2 BYTE),
NBR CHAR(3 BYTE),
MODEL   CHAR(1 BYTE),
LINE    CHAR(1 BYTE),
YMD NUMBER(8,0)
);
create table process(
DIV CHAR(4 BYTE),
PAID    CHAR(2 BYTE),
NBR CHAR(3 BYTE),
BANK    CHAR(2 BYTE),
UNIT    CHAR(2 BYTE),
CAR CHAR(2 BYTE)
);
BEGIN
INSERT INTO SERVICE (NBR,   LINE,   PAID,   DIV,    MODEL,  YMD) values ('555', '1',    'NY',   'AR91', '6',    20240311);
INSERT INTO SERVICE (NBR,   LINE,   PAID,   DIV,    MODEL,  YMD) values ('555', '2',    'NY',   'AR91', '6',    20240311);
INSERT INTO SERVICE (NBR,   LINE,   PAID,   DIV,    MODEL,  YMD) values ('555', '3',    'NY',   'ZZ1',  '6',    20240311);
INSERT INTO SERVICE (NBR,   LINE,   PAID,   DIV,    MODEL,  YMD) values ('556', '1',    'NY',   'AR10', '8',    20240311);
INSERT INTO SERVICE (NBR,   LINE,   PAID,   DIV,    MODEL,  YMD) values ('556', '2',    'NY',   'ZZ1',  '8',    20240311);
INSERT INTO SERVICE (NBR,   LINE,   PAID,   DIV,    MODEL,  YMD) values ('557', '1',    'NY',   'AR10', '9',    20240311);
INSERT INTO SERVICE (NBR,   LINE,   PAID,   DIV,    MODEL,  YMD) values ('600', '1',    'NY',   'ZZ1',  '5',    20240311);
INSERT INTO SERVICE (NBR,   LINE,   PAID,   DIV,    MODEL,  YMD) values ('601', '1',    'NY',   'ZZ1',  '7',    20240311);

INSERT INTO PROCESS (NBR,   DIV,    CAR,    BANK,   UNIT,   PAID) values ('555','AR91','M','1','MC','NY');
INSERT INTO PROCESS (NBR,   DIV,    CAR,    BANK,   UNIT,   PAID) values ('556','AR91','M','1','MC','NY');
INSERT INTO PROCESS (NBR,   DIV,    CAR,    BANK,   UNIT,   PAID) values ('557','AR10','M','1','MC','NY');
INSERT INTO PROCESS (NBR,   DIV,    CAR,    BANK,   UNIT,   PAID) values ('600','ZZ1','M','1','MC','NY');
INSERT INTO PROCESS (NBR,   DIV,    CAR,    BANK,   UNIT,   PAID) values ('601','ZZ1','M','1','MC','NY');
  END;
/
1 rows affected

SELECT s.nbr,
       s.model
FROM   process p
       INNER JOIN (
         SELECT *
         FROM   (
           SELECT s.*,
                  COUNT(
                    CASE
                    WHEN s.div IN ('AR91', 'AR10', 'AG55', 'AZ56', 'CZ12')
                    THEN 1
                    END
                  ) OVER (PARTITION BY s.nbr) AS num_div
           FROM   service s
         )
         WHERE  num_div = 0
       ) s
       ON p.nbr = s.nbr
WHERE  p.unit = 'MC'
AND    p.car = 'M'
AND    p.bank = '1'
AND    p.paid in ('NY', 'NJ')
AND    s.paid = 'NY'
AND    TO_DATE(s.ymd DEFAULT NULL ON CONVERSION ERROR, 'YYYYMMDD')
         BETWEEN DATE '2024-03-03' AND DATE '2024-03-11'


NBR
MODEL


600
5

601
7