[Home] [Help]
425: CLOSE c2;
426:
427: IF (recInfoForHist.LEASE_CHANGE_ID <> X_LEASE_CHANGE_ID) THEN
428:
429: SELECT PN_RIGHTS_HISTORY_S.NEXTVAL
430: INTO l_rightHistoryId
431: FROM DUAL;
432:
433: INSERT INTO PN_RIGHTS_HISTORY
429: SELECT PN_RIGHTS_HISTORY_S.NEXTVAL
430: INTO l_rightHistoryId
431: FROM DUAL;
432:
433: INSERT INTO PN_RIGHTS_HISTORY
434: (
435: RIGHT_HISTORY_ID,
436: RIGHT_ID,
437: LAST_UPDATE_DATE,