DBA Data[Home] [Help]

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;