APPS.PN_OPTIONS_PKG dependencies on PN_OPTIONS_HISTORY
Line 507: SELECT pn_options_history_s.NEXTVAL
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
Line 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,