APPS.IGS_PS_GEN_008 dependencies on IGS_GE_NOTE_RF_NUM_S

Line 86: SELECT IGS_GE_NOTE_RF_NUM_S.nextval

82: AS
83: BEGIN
84: DECLARE
85: CURSOR c_note_seq IS
86: SELECT IGS_GE_NOTE_RF_NUM_S.nextval
87: FROM dual;
88: CURSOR c_note IS
89: SELECT IGS_GE_NOTE.s_note_format_type,
90: IGS_GE_NOTE.note_text

Line 746: SELECT IGS_GE_NOTE_RF_NUM_S.nextval

742: FROM IGS_GE_NOTE
743: WHERE reference_number = p_existing_ref_number;
744: BEGIN
745: --- Get new reference number
746: SELECT IGS_GE_NOTE_RF_NUM_S.nextval
747: INTO p_new_ref_number
748: FROM dual;
749: --- Get related IGS_GE_NOTE and insert under new reference number
750: