APPS.IGS_PS_GEN_006 dependencies on IGS_EN_UNIT_SET_STAT

Line 238: -- IGS_PS_UNIT set from the IGS_EN_UNIT_SET_STAT table.

234: BEGIN
235:
236: -- crsp_get_us_sys_sts
237: -- This module fetches the value for the system IGS_PS_UNIT set status for a
238: -- IGS_PS_UNIT set from the IGS_EN_UNIT_SET_STAT table.
239: DECLARE
240:
241: v_uss_s_unit_set_status IGS_EN_UNIT_SET.unit_set_status%TYPE;
242: CURSOR c_uss IS

Line 244: FROM IGS_EN_UNIT_SET_STAT uss

240:
241: v_uss_s_unit_set_status IGS_EN_UNIT_SET.unit_set_status%TYPE;
242: CURSOR c_uss IS
243: SELECT uss.s_unit_set_status
244: FROM IGS_EN_UNIT_SET_STAT uss
245: WHERE uss.unit_set_status = p_unit_set_status;
246: BEGIN
247: -- Get the system IGS_PS_UNIT set status
248: OPEN c_uss;