APPS.IGS_CO_VAL_SLET dependencies on IGS_LOOKUPS_VIEW

Line 19: v_closed_ind IGS_LOOKUPS_view.closed_ind%TYPE DEFAULT NULL;

15:
16: BEGIN -- corp_val_slo_closed
17: -- Validate if s_letter_object is closed.
18: DECLARE
19: v_closed_ind IGS_LOOKUPS_view.closed_ind%TYPE DEFAULT NULL;
20: CURSOR c_slo IS
21: SELECT closed_ind
22: FROM IGS_LOOKUPS_view
23: WHERE lookup_code = p_s_letter_object

Line 22: FROM IGS_LOOKUPS_view

18: DECLARE
19: v_closed_ind IGS_LOOKUPS_view.closed_ind%TYPE DEFAULT NULL;
20: CURSOR c_slo IS
21: SELECT closed_ind
22: FROM IGS_LOOKUPS_view
23: WHERE lookup_code = p_s_letter_object
24: AND lookup_type='LETTER_OBJECT';
25: BEGIN
26: p_message_name := Null;