DBA Data[Home] [Help]

APPS.PN_OPTIONS_PKG dependencies on DUAL

Line 92: FROM DUAL;

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,