APPS.IGS_RE_VAL_TPM dependencies on IGS_RE_THS_PNL_TYPE

Line 23: v_tpt_recommended_panel_size IGS_RE_THS_PNL_TYPE.recommended_panel_size%TYPE;

19: p_message_name OUT NOCOPY VARCHAR2 )
20: RETURN BOOLEAN AS
21: BEGIN -- func_module
22: DECLARE
23: v_tpt_recommended_panel_size IGS_RE_THS_PNL_TYPE.recommended_panel_size%TYPE;
24: v_panel_cnt NUMBER;
25: CURSOR c_tpt IS
26: SELECT tpt.recommended_panel_size
27: FROM IGS_RE_THS_PNL_TYPE tpt

Line 27: FROM IGS_RE_THS_PNL_TYPE tpt

23: v_tpt_recommended_panel_size IGS_RE_THS_PNL_TYPE.recommended_panel_size%TYPE;
24: v_panel_cnt NUMBER;
25: CURSOR c_tpt IS
26: SELECT tpt.recommended_panel_size
27: FROM IGS_RE_THS_PNL_TYPE tpt
28: WHERE thesis_panel_type = p_thesis_panel_type;
29: CURSOR c_tpm IS
30: SELECT count('x')
31: FROM IGS_RE_THS_PNL_MBR tpm