Courtesy lights fault

[owler]

Audi A4 2002 B6. Rear courtesy light not working but the map reading lights do. The right rear door red light on open and the rear footwell lights are not working. The left rear is working perfectly but once again don't operate the rear overhead courtesy light.
I have checked for power at both the door lamp and footwell lamp situated in the underside of the drivers seat. In the door lamp I have a permanent Earth but no positive. when I feed a positive from inside the pillar it works, so no broken wire entering the door.
Also have checked inside rubber bellows, all good.
The lamp on the underside of the drivers seat has permanent positive but no earth.
I would expect that both these wires come from the comfort control module.
So I raised the carpet on the Passengers side and its as dry as a bone. Not one hint of moisture. The module looks like new and all the connectors look perfect.
Is it possible to get a wiring diagram for the module??
I am at my wits end.

[spartacus 68]

Just wondering if the courtesy lights operate via the door handle microswitch. Had a similar issue with my B5 footwell lights.