DBA Data[Home] [Help]

APPS.IGS_RE_GEN_003 dependencies on IGS_RE_THS_PNL_TYPE

Line 289: cp_thesis_panel_type IGS_RE_THS_PNL_TYPE.thesis_panel_type%TYPE) IS

285: rst.research_supervisor_type = rsup.research_supervisor_type AND
286: rst.principal_supervisor_ind = 'Y'
287: ORDER BY rsup.supervision_percentage DESC;
288: CURSOR c_tpt (
289: cp_thesis_panel_type IGS_RE_THS_PNL_TYPE.thesis_panel_type%TYPE) IS
290: SELECT tpt.tracking_type
291: FROM IGS_RE_THS_PNL_TYPE tpt
292: WHERE tpt.thesis_panel_type = cp_thesis_panel_type;
293: CURSOR c_ts IS

Line 291: FROM IGS_RE_THS_PNL_TYPE tpt

287: ORDER BY rsup.supervision_percentage DESC;
288: CURSOR c_tpt (
289: cp_thesis_panel_type IGS_RE_THS_PNL_TYPE.thesis_panel_type%TYPE) IS
290: SELECT tpt.tracking_type
291: FROM IGS_RE_THS_PNL_TYPE tpt
292: WHERE tpt.thesis_panel_type = cp_thesis_panel_type;
293: CURSOR c_ts IS
294: SELECT ts.tracking_status
295: FROM IGS_TR_STATUS ts