[Home] [Help]
494: CLOSE c2;
495:
496: IF (recInfoForHist.LEASE_CHANGE_ID <> X_LEASE_CHANGE_ID) THEN
497:
498: SELECT PN_LANDLORD_SERVICE_HISTORY_S.NEXTVAL
499: INTO l_llserviceHistoryId
500: FROM DUAL;
501:
502: INSERT INTO PN_LANDLORD_SERVICE_HISTORY
498: SELECT PN_LANDLORD_SERVICE_HISTORY_S.NEXTVAL
499: INTO l_llserviceHistoryId
500: FROM DUAL;
501:
502: INSERT INTO PN_LANDLORD_SERVICE_HISTORY
503: (
504: LANDLORD_SERVICE_HISTORY_ID,
505: LANDLORD_SERVICE_ID,
506: LAST_UPDATE_DATE,