DBA Data[Home] [Help]

APPS.IGS_EN_WORKFLOW dependencies on IGS_RE_THESIS

Line 729: igs_re_thesis ret

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
733: AND esp.person_id = rec.person_id