APPS.IGS_EN_GEN_005 dependencies on IGS_PS_PAT_STUDY_UNT

Line 191: FROM IGS_PS_PAT_STUDY_UNT posu,

187: (pee.course_cd IS NULL OR
188: pee.course_cd = p_course_cd) AND
189: NOT EXISTS (
190: SELECT 'X'
191: FROM IGS_PS_PAT_STUDY_UNT posu,
192: IGS_PS_PAT_STUDY_PRD posp
193: WHERE posu.course_cd = p_course_cd AND
194: posu.version_number = p_version_number AND
195: posu.cal_type = p_acad_cal_type AND

Line 207: FROM IGS_PS_PAT_STUDY_UNT posu,

203: posp.acad_period_num = p_acad_period_num);
204: CURSOR c_posu_posp IS
205: SELECT posu.unit_cd,
206: posp.teach_cal_type
207: FROM IGS_PS_PAT_STUDY_UNT posu,
208: IGS_PS_PAT_STUDY_PRD posp
209: WHERE posu.course_cd = p_course_cd AND
210: posu.version_number = p_version_number AND
211: posu.cal_type = p_acad_cal_type AND

Line 220: CURSOR c_sua (cp_posu_unit_cd IGS_PS_PAT_STUDY_UNT.unit_cd%TYPE,

216: posp.cal_type = posu.cal_type AND
217: posp.pos_sequence_number = posu.pos_sequence_number AND
218: posp.sequence_number = posu.posp_sequence_number AND
219: posp.acad_period_num < p_acad_period_num;
220: CURSOR c_sua (cp_posu_unit_cd IGS_PS_PAT_STUDY_UNT.unit_cd%TYPE,
221: cp_posp_teach_cal_type IGS_PS_PAT_STUDY_PRD.teach_cal_type%TYPE) IS
222: SELECT 'X'
223: FROM IGS_EN_SU_ATTEMPT sua
224: WHERE sua.person_id = p_person_id AND