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_RE_CANDIDATURE

Line 724: CURSOR cur_offset_days(cp_offset_date igs_re_candidature_all.research_topic%TYPE) IS

720: WHERE closed_ind='N'
721: AND s_cal_cat = 'ACADEMIC'
722: AND cal_type = p_acad_cal_type;
723:
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,

Line 727: FROM igs_re_candidature rec,

723:
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 )