APPS.IGS_PS_VAL_CAW dependencies on IGS_PS_TYPE

Line 47: v_award_crs_ind IGS_PS_TYPE.award_course_ind%TYPE;

43: p_course_cd IN VARCHAR2 ,
44: p_version_number IN NUMBER ,
45: p_message_name OUT NOCOPY VARCHAR2 )
46: RETURN BOOLEAN AS
47: v_award_crs_ind IGS_PS_TYPE.award_course_ind%TYPE;
48: CURSOR c_get_award_crs_ind IS
49: SELECT award_course_ind
50: FROM IGS_PS_VER,
51: IGS_PS_TYPE

Line 51: IGS_PS_TYPE

47: v_award_crs_ind IGS_PS_TYPE.award_course_ind%TYPE;
48: CURSOR c_get_award_crs_ind IS
49: SELECT award_course_ind
50: FROM IGS_PS_VER,
51: IGS_PS_TYPE
52: WHERE course_cd = p_course_cd AND
53: version_number = p_version_number AND
54: IGS_PS_VER.course_type = IGS_PS_TYPE.course_type;
55: BEGIN

Line 54: IGS_PS_VER.course_type = IGS_PS_TYPE.course_type;

50: FROM IGS_PS_VER,
51: IGS_PS_TYPE
52: WHERE course_cd = p_course_cd AND
53: version_number = p_version_number AND
54: IGS_PS_VER.course_type = IGS_PS_TYPE.course_type;
55: BEGIN
56: OPEN c_get_award_crs_ind;
57: FETCH c_get_award_crs_ind INTO v_award_crs_ind;
58: IF (c_get_award_crs_ind%FOUND) THEN