APPS.IGS_RE_VAL_TEX dependencies on IGS_RE_THS_PNL_TYPE

Line 679: v_recommended_panel_size IGS_RE_THS_PNL_TYPE.recommended_panel_size%TYPE;

675: v_records_found BOOLEAN;
676: v_result_match BOOLEAN;
677: v_record_count NUMBER;
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;

Line 695: FROM IGS_RE_THS_PNL_TYPE tpt

691: tpm.confirmed_dt IS NOT NULL AND
692: tpm.thesis_result_cd IS NOT NULL;
693: CURSOR c_tpt IS
694: SELECT tpt.recommended_panel_size
695: FROM IGS_RE_THS_PNL_TYPE tpt
696: WHERE tpt.thesis_panel_type = p_thesis_panel_type;
697: CURSOR c_tpmc IS
698: SELECT confirmed_dt
699: FROM IGS_RE_THS_PNL_MBR tpm

Line 840: FROM IGS_RE_THS_PNL_TYPE tpt

836: DECLARE
837: v_dummy VARCHAR2(1);
838: CURSOR c_tpt IS
839: SELECT 'x'
840: FROM IGS_RE_THS_PNL_TYPE tpt
841: WHERE tpt.thesis_panel_type = p_thesis_panel_type AND
842: tpt.closed_ind = 'Y';
843: BEGIN
844: -- set default value