eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_GEN_010 dependencies on DUAL

Line 2900: FROM DUAL;

2896: INTO v_unit_cd,
2897: v_cal_type,
2898: v_location_cd,
2899: v_unit_class
2900: FROM DUAL;
2901: IF v_unit_cd IS NOT NULL THEN
2902: p_added_ind := 'Y';
2903: -- Call routine to check whether there is anything preventing
2904: -- the IGS_PS_UNIT attempt from being pre-enrolled (ie. advanced

Line 4557: FROM DUAL;

4553: INTO v_unit_cd,
4554: v_cal_type,
4555: v_location_cd,
4556: v_unit_class
4557: FROM DUAL;
4558:
4559: IF v_unit_cd IS NOT NULL THEN
4560: p_added_ind := 'Y';
4561: -- Call routine to check whether there is anything preventing

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 8340: FROM dual;

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;
8343: v_confirmed_ind := NVL(p_confirmed_ind,'N') ;
8344: IF v_confirmed_ind = 'Y' THEN