[Home] [Help]
503: CLOSE c2;
504:
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
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,
514: option_id,
515: last_update_date,