DBA Data[Home] [Help]

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,