DBA Data[Home] [Help]

APPS.IGS_AD_VAL_ITT dependencies on IGS_LOOKUPS_VIEW

Line 13: v_closed_ind IGS_LOOKUPS_VIEW.closed_ind%TYPE;

9: RETURN BOOLEAN AS
10: BEGIN -- admp_val_sitt_closed
11: -- Validate if s_intake_target_type.s_intake_target_type is closed.
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'