APPS.IGS_SS_EN_WRAPPERS dependencies on IGS_EN_STDNT_PS_ATT_ALL

Line 4703: FROM igs_en_stdnt_ps_att_all spat

4699: AS
4700: --cursor to get the rowid for the program attempt of the student
4701: CURSOR cur_program(p_person_id NUMBER, p_course_cd VARCHAR2) IS
4702: SELECT spat.ROWID
4703: FROM igs_en_stdnt_ps_att_all spat
4704: WHERE spat.person_id = p_person_id
4705: AND spat.course_cd = p_course_cd;
4706:
4707: --cursor to get the rowid for the unit attempt of the student

Line 4727: IF p_table ='IGS_EN_STDNT_PS_ATT_ALL' THEN

4723: p_update_allowed := 'N';
4724: l_program_rowid := NULL;
4725:
4726: -- get the program attempt rowid
4727: IF p_table ='IGS_EN_STDNT_PS_ATT_ALL' THEN
4728: --get the rowid for program attempt
4729: OPEN cur_program(p_person_id,p_course_cd);
4730: FETCH cur_program INTO l_program_rowid;
4731: CLOSE cur_program;