74: IF ( X_RIGHT_ID IS NULL) THEN
75:
76: SELECT pn_rights_s.NEXTVAL
77: INTO x_right_id 78: FROM DUAL; 79: END IF;
80:
81: IF x_org_id IS NULL THEN
82: FOR rec IN org_cur LOOP
Line 431: FROM DUAL;
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
434: (
435: RIGHT_HISTORY_ID,