APPS.IGS_PS_GEN_001 dependencies on IGS_GE_NOTE_RF_NUM_S

Line 279: SELECT IGS_GE_NOTE_RF_NUM_S.NEXTVAL

275:
276: -- Removed cursor gc_revseg_rec as part of Enh# 2831572.
277:
278: CURSOR gc_ref_num IS
279: SELECT IGS_GE_NOTE_RF_NUM_S.NEXTVAL
280: FROM DUAL;
281: CURSOR gc_coo_seq_num IS
282: SELECT IGS_PS_OFR_OPT_COO_ID_S.NEXTVAL
283: FROM DUAL;

Line 3666: SELECT IGS_GE_NOTE_RF_NUM_S.NEXTVAL INTO lnnote_ref_number FROM dual;

3662: IF cur_c_unt_ofr_opt_n_new%NOTFOUND THEN
3663: --insert a record in the igs_ge_note table corresponding to the reference number create
3664: -- for unit section note.
3665:
3666: SELECT IGS_GE_NOTE_RF_NUM_S.NEXTVAL INTO lnnote_ref_number FROM dual;
3667:
3668: igs_ge_note_pkg.insert_row(
3669: x_rowid => lv_gerowid,
3670: x_reference_number => lnnote_ref_number ,