APPS.IGS_AD_VAL_ITT dependencies on IGS_LOOKUP_VALUES
Line 16: FROM IGS_LOOKUP_VALUES
12: DECLARE
13: v_closed_ind IGS_LOOKUPS_VIEW.closed_ind%TYPE;
14: CURSOR c_sitt IS
15: SELECT closed_ind 16: FROM IGS_LOOKUP_VALUES 17: WHERE lookup_type = 'INTAKE_TARGET_TYPE'
18: AND lookup_code = p_s_intake_target_type;
19: BEGIN
20: OPEN c_sitt;