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_WORKFLOW dependencies on IGS_EN_STDNT_PS_ATT

Line 242: igs_en_stdnt_ps_att espa,

238:
239: CURSOR cur_prog_type IS
240: SELECT course_type
241: FROM
242: igs_en_stdnt_ps_att espa,
243: igs_ps_ver psv
244: WHERE
245: psv.course_cd = espa.course_cd
246: AND psv.version_number = espa.version_number

Line 728: igs_en_stdnt_ps_att esp,

724: CURSOR cur_offset_days(cp_offset_date igs_re_candidature_all.research_topic%TYPE) IS
725: SELECT rec.person_id,rec.max_submission_dt, esp.course_cd, ret.ca_sequence_number, ret.sequence_number
726: ,ret.logical_delete_dt,ret.thesis_result_cd , ret.title , rec.sequence_number can_sequence_number
727: FROM igs_re_candidature rec,
728: igs_en_stdnt_ps_att esp,
729: igs_re_thesis ret
730: WHERE max_submission_dt IS NOT NULL
731: AND max_submission_dt = (trunc(SYSDATE) - cp_offset_date )
732: AND esp.course_cd = rec.sca_course_cd