APPS.IGS_TR_GEN_002 dependencies on DUAL

Line 683: SELECT igs_ge_note_rf_num_s.NEXTVAL INTO v_next_ref_number FROM dual;

679:
680: OPEN c_note;
681: FETCH c_note INTO v_s_note_format_type, v_note_text;
682: CLOSE c_note;
683: SELECT igs_ge_note_rf_num_s.NEXTVAL INTO v_next_ref_number FROM dual;
684:
685: p_new_reference_number := v_next_ref_number;
686: igs_ge_note_pkg.insert_row(
687: x_rowid => p_rowid,

Line 967: FROM dual;

963: WHERE person_id = cp_person_id;
964:
965: CURSOR c_tri_nxt_seq_num IS
966: SELECT igs_tr_item_tr_id_s.NEXTVAL
967: FROM dual;
968:
969: BEGIN
970:
971: p_message_name := NULL;