Or, you could do this:
Code:
BEGIN
  BEGIN
    SELECT seats_held INTO l_fcc_held
      FROM flt_cabin_capacity
    WHERE cabin = c_cabin.cabin
        AND physical_flight_id = l_physical_flight_id
        AND actual_depart_date = l_departure_date;
  EXCEPTION
    WHEN NO_DATA_FOUND THEN
          l_fcc_held := 0;
   END;
  -- Procedure Continues here...
END;
/
Or this:

Code:
BEGIN
  SELECT seats_held INTO l_fcc_held
    FROM flt_cabin_capacity
  WHERE cabin = c_cabin.cabin
      AND physical_flight_id = l_physical_flight_id
      AND actual_depart_date = l_departure_date;
  IF SQL%NOTFOUND
  THEN
      l_fcc_held := 0;
  END IF:
-- Procedure Continues here...
END;