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_005 dependencies on IGS_PS_PAT_STUDY_PRD

Line 192: IGS_PS_PAT_STUDY_PRD posp

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
196: posu.pos_sequence_number = p_pos_sequence_number AND

Line 208: IGS_PS_PAT_STUDY_PRD posp

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
212: posu.pos_sequence_number = p_pos_sequence_number AND

Line 221: cp_posp_teach_cal_type IGS_PS_PAT_STUDY_PRD.teach_cal_type%TYPE) IS

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
225: sua.course_cd = p_course_cd AND

Line 243: FROM IGS_PS_PAT_STUDY_PRD posp

239: gsg.grade = suaov.grade AND
240: gsg.s_result_type IN (cst_pass,cst_incomp))));
241: CURSOR c_posp IS
242: SELECT teach_cal_type
243: FROM IGS_PS_PAT_STUDY_PRD posp
244: WHERE posp.course_cd = p_course_cd AND
245: posp.version_number = p_version_number AND
246: posp.cal_type = p_acad_cal_type AND
247: posp.pos_sequence_number = p_pos_sequence_number AND

Line 249: CURSOR c_cir_tci (cp_teach_cal_type IGS_PS_PAT_STUDY_PRD.teach_cal_type%TYPE)

245: posp.version_number = p_version_number AND
246: posp.cal_type = p_acad_cal_type AND
247: posp.pos_sequence_number = p_pos_sequence_number AND
248: posp.acad_period_num = p_acad_period_num;
249: CURSOR c_cir_tci (cp_teach_cal_type IGS_PS_PAT_STUDY_PRD.teach_cal_type%TYPE)
250: IS
251: SELECT tci.cal_type,
252: tci.sequence_number
253: FROM IGS_CA_INST_REL cir,