APPS.IGS_RE_VAL_THE dependencies on IGS_LOOKUPS_VIEW

Line 376: v_final_result_ind IGS_LOOKUPS_VIEW.final_result_ind%TYPE;

372: cst_pending CONSTANT VARCHAR2(10) := 'PENDING';
373: v_dummy VARCHAR2(1);
374: v_thesis_status IGS_RE_THESIS_V.thesis_status%TYPE;
375: v_closed_ind IGS_RE_THESIS_RESULT.closed_ind%TYPE;
376: v_final_result_ind IGS_LOOKUPS_VIEW.final_result_ind%TYPE;
377: v_thesis_result_cd IGS_RE_THESIS_EXAM.thesis_result_cd%TYPE;
378: CURSOR c_thev IS
379: SELECT thev.thesis_status
380: FROM IGS_RE_THESIS_V thev

Line 398: IGS_LOOKUPS_VIEW sthr

394: CURSOR c_thr_sthr IS
395: SELECT thr.closed_ind,
396: sthr.final_result_ind
397: FROM IGS_RE_THESIS_RESULT thr,
398: IGS_LOOKUPS_VIEW sthr
399: WHERE thr.thesis_result_cd = p_thesis_result_cd AND
400: sthr.LOOKUP_CODE = thr.s_thesis_result_cd
401: AND sthr.lookup_type = 'THESIS_RESULT';
402: