APPS.IGS_EN_VAL_DR dependencies on IGS_LOOKUPS_VIEW

Line 45: v_closed_ind IGS_LOOKUPS_VIEW.closed_ind%TYPE;

41:
42: BEGIN -- enrp_val_sdrt_closed
43: -- This module validates that s_discontinuation_reason_type is not closed.
44: DECLARE
45: v_closed_ind IGS_LOOKUPS_VIEW.closed_ind%TYPE;
46: CURSOR c_sdrt IS
47: SELECT closed_ind
48: FROM IGS_LOOKUPS_VIEW sdrt
49: WHERE lookup_type = 'DISCONTINUATION_REASON_TYPE' and

Line 48: FROM IGS_LOOKUPS_VIEW sdrt

44: DECLARE
45: v_closed_ind IGS_LOOKUPS_VIEW.closed_ind%TYPE;
46: CURSOR c_sdrt IS
47: SELECT closed_ind
48: FROM IGS_LOOKUPS_VIEW sdrt
49: WHERE lookup_type = 'DISCONTINUATION_REASON_TYPE' and
50: lookup_code = p_s_discontin_reason_type;
51: BEGIN
52: p_message_name := null;