DBA Data[Home] [Help]

APPS.IGS_PS_CAL_RSR_VAL dependencies on IGS_EN_SU_ATTEMPT_ALL

Line 121: CURSOR cur_check_enr (cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS

117: uoov.version_number=uv.version_number AND
118: uv.unit_status=st.unit_status AND
119: st.s_unit_status <>'INACTIVE';
120:
121: CURSOR cur_check_enr (cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
122: SELECT 'X'
123: FROM igs_en_su_attempt_all
124: WHERE uoo_id= cp_uoo_id
125: AND ROWNUM <2;

Line 123: FROM igs_en_su_attempt_all

119: st.s_unit_status <>'INACTIVE';
120:
121: CURSOR cur_check_enr (cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
122: SELECT 'X'
123: FROM igs_en_su_attempt_all
124: WHERE uoo_id= cp_uoo_id
125: AND ROWNUM <2;
126: l_c_var VARCHAR2(1);
127: