APPS.IGS_RE_VAL_TEX dependencies on IGS_RE_THESIS_RESULT

Line 200: IGS_RE_THESIS_RESULT thr

196: v_dummy VARCHAR2(1);
197: CURSOR c_tpm IS
198: SELECT 'x'
199: FROM IGS_RE_THS_PNL_MBR tpm,
200: IGS_RE_THESIS_RESULT thr
201: WHERE tpm.person_id = p_person_id AND
202: tpm.ca_sequence_number = p_ca_sequence_number AND
203: tpm.the_sequence_number = p_the_sequence_number AND
204: tpm.creation_dt = p_creation_dt AND

Line 674: v_closed_ind IGS_RE_THESIS_RESULT.closed_ind%TYPE;

670: -- Cannot be cleared if IGS_RE_THESIS has been EXAMINED (ie. final result entered).
671: DECLARE
672: cst_examined CONSTANT VARCHAR2(10) := 'EXAMINED';
673: v_dummy VARCHAR2(1);
674: v_closed_ind IGS_RE_THESIS_RESULT.closed_ind%TYPE;
675: v_records_found BOOLEAN;
676: v_result_match BOOLEAN;
677: v_record_count NUMBER;
678: v_confirmed_count NUMBER;

Line 682: FROM IGS_RE_THESIS_RESULT thr

678: v_confirmed_count NUMBER;
679: v_recommended_panel_size IGS_RE_THS_PNL_TYPE.recommended_panel_size%TYPE;
680: CURSOR c_thr IS
681: SELECT thr.closed_ind
682: FROM IGS_RE_THESIS_RESULT thr
683: WHERE thr.thesis_result_cd = p_thesis_result_cd;
684: CURSOR c_tpm IS
685: SELECT tpm.thesis_result_cd
686: FROM IGS_RE_THS_PNL_MBR tpm