88:
89: IF ( X_OPTION_ID IS NULL) THEN
90: SELECT pn_options_s.NEXTVAL
91: INTO x_option_id 92: FROM DUAL; 93: END IF;
94:
95: INSERT INTO pn_options_all
96: (
Line 509: FROM DUAL;
505: IF (recInfoForHist.LEASE_CHANGE_ID <> X_LEASE_CHANGE_ID) THEN
506:
507: SELECT pn_options_history_s.NEXTVAL
508: INTO l_optionHistoryId 509: FROM DUAL; 510:
511: INSERT INTO pn_options_history
512: (
513: option_history_id,