APPS.IGS_PS_VAL_US dependencies on IGS_EN_UNIT_SET_CAT

Line 60: v_closed_ind IGS_EN_UNIT_SET_CAT.closed_ind%TYPE;

56: RETURN BOOLEAN AS
57: BEGIN --crsp_val_usc_closed
58: -- Validate the IGS_PS_UNIT set closed closed indicator
59: DECLARE
60: v_closed_ind IGS_EN_UNIT_SET_CAT.closed_ind%TYPE;
61: CURSOR c_usc IS
62: SELECT usc.closed_ind
63: FROM IGS_EN_UNIT_SET_CAT usc
64: WHERE usc.unit_set_cat = p_unit_set_cat;

Line 63: FROM IGS_EN_UNIT_SET_CAT usc

59: DECLARE
60: v_closed_ind IGS_EN_UNIT_SET_CAT.closed_ind%TYPE;
61: CURSOR c_usc IS
62: SELECT usc.closed_ind
63: FROM IGS_EN_UNIT_SET_CAT usc
64: WHERE usc.unit_set_cat = p_unit_set_cat;
65: BEGIN
66: --set default message number
67: p_message_name := NULL;