APPS.IGS_EN_GEN_010 dependencies on IGS_AS_SU_SETATMPT_SEQ_NUM_S

Line 8012: SELECT IGS_AS_SU_SETATMPT_SEQ_NUM_S.NEXTVAL INTO vl_sequence_val FROM dual;

8008: END IF;
8009:
8010: IF c_susa_exists%NOTFOUND THEN
8011:
8012: SELECT IGS_AS_SU_SETATMPT_SEQ_NUM_S.NEXTVAL INTO vl_sequence_val FROM dual;
8013:
8014: IF igs_en_gen_legacy.check_usa_overlap(
8015: p_person_id,
8016: p_course_cd,

Line 8338: SELECT IGS_AS_SU_SETATMPT_SEQ_NUM_S.NEXTVAL

8334: );
8335: END IF;
8336: ELSE
8337: CLOSE c_next_susa_exists;
8338: SELECT IGS_AS_SU_SETATMPT_SEQ_NUM_S.NEXTVAL
8339: INTO l_seqval
8340: FROM dual;
8341:
8342: p_seqval := l_seqval;