APPS.IGS_PS_GEN_006 dependencies on IGS_AS_UNIT_CLASS

Line 51: CURSOR c_ucl (cp_unit_class IGS_AS_UNIT_CLASS.unit_class%TYPE) IS

47:
48: FUNCTION crsp_get_ucl_mode(
49: p_unit_class IN VARCHAR2 )
50: RETURN VARCHAR2 AS
51: CURSOR c_ucl (cp_unit_class IGS_AS_UNIT_CLASS.unit_class%TYPE) IS
52: SELECT unit_mode
53: FROM IGS_AS_UNIT_CLASS
54: WHERE unit_class = cp_unit_class
55: AND closed_ind = 'N';

Line 53: FROM IGS_AS_UNIT_CLASS

49: p_unit_class IN VARCHAR2 )
50: RETURN VARCHAR2 AS
51: CURSOR c_ucl (cp_unit_class IGS_AS_UNIT_CLASS.unit_class%TYPE) IS
52: SELECT unit_mode
53: FROM IGS_AS_UNIT_CLASS
54: WHERE unit_class = cp_unit_class
55: AND closed_ind = 'N';
56: v_unit_mode IGS_AS_UNIT_CLASS.unit_mode%TYPE;
57: BEGIN

Line 56: v_unit_mode IGS_AS_UNIT_CLASS.unit_mode%TYPE;

52: SELECT unit_mode
53: FROM IGS_AS_UNIT_CLASS
54: WHERE unit_class = cp_unit_class
55: AND closed_ind = 'N';
56: v_unit_mode IGS_AS_UNIT_CLASS.unit_mode%TYPE;
57: BEGIN
58: IF p_unit_class IS NULL THEN
59: RETURN NULL;
60: ELSE