APPS.IGS_PS_VAL_USC dependencies on IGS_EN_UNIT_SET

Line 18: v_s_unit_set_status IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;

14: BEGIN -- crsp_val_usc_us
15: -- This module provides a warning if the IGS_PS_UNIT set is active
16: -- when the IGS_PS_UNIT set category is being changed.
17: DECLARE
18: v_s_unit_set_status IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;
19: CURSOR c_us IS
20: SELECT us.unit_set_cd
21: FROM IGS_EN_UNIT_SET us
22: WHERE us.unit_set_cat = p_unit_set_cat;

Line 21: FROM IGS_EN_UNIT_SET us

17: DECLARE
18: v_s_unit_set_status IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;
19: CURSOR c_us IS
20: SELECT us.unit_set_cd
21: FROM IGS_EN_UNIT_SET us
22: WHERE us.unit_set_cat = p_unit_set_cat;
23: BEGIN
24: -- Set the default message number
25: p_message_name := NULL;