APPS.IGS_PS_GEN_001 dependencies on IGS_PS_OFR_OPT_COO_ID_S

Line 282: SELECT IGS_PS_OFR_OPT_COO_ID_S.NEXTVAL

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;
284:
285: -- procedure for inserting new IGS_GE_NOTE and IGS_PS_OFR_OPT_NOTE records
286: PROCEDURE crsp_ins_coon_rec (