PAMInspection

must read the location address, not company address
so update the Query while inspection type = 9 تفتيش سلامة مهنية - موقع سكن
if AUTO_NUM_PACI is not null
select AUTO_NUM_PACI from INS_LOCATION_HOUSING where LOC_HOUSE_ID =:P_LOC_HOUSE_ID and AUTO_NUM_PACI is not null ;

if AUTO_NUM_PACI is null
select SYS_PKG.GET_LOOKUP_NAME (2,GOVERNORATE_ID) , 'احداثيات ' || ',x=' || LOCATION_X || ' y=' || LOCATION_Y
from INS_LOCATION_HOUSING where LOC_HOUSE_ID = :P_LOC_HOUSE_ID and
AUTO_NUM_PACI is null ;