APPS.IGS_AD_VAL_CEPI dependencies on IGS_PS_STAT

Line 44: v_s_course_status IGS_PS_STAT.s_course_status%TYPE;

40: p_version_number IN NUMBER ,
41: p_message_name OUT NOCOPY VARCHAR2 )
42: RETURN BOOLEAN IS
43: v_other_detail VARCHAR2(255);
44: v_s_course_status IGS_PS_STAT.s_course_status%TYPE;
45: CURSOR c_get_s_course_status IS
46: SELECT s_course_status
47: FROM IGS_PS_VER,
48: IGS_PS_STAT

Line 48: IGS_PS_STAT

44: v_s_course_status IGS_PS_STAT.s_course_status%TYPE;
45: CURSOR c_get_s_course_status IS
46: SELECT s_course_status
47: FROM IGS_PS_VER,
48: IGS_PS_STAT
49: WHERE course_cd = p_course_cd AND
50: version_number = p_version_number AND
51: IGS_PS_VER.course_status = IGS_PS_STAT.course_status;
52: BEGIN

Line 51: IGS_PS_VER.course_status = IGS_PS_STAT.course_status;

47: FROM IGS_PS_VER,
48: IGS_PS_STAT
49: WHERE course_cd = p_course_cd AND
50: version_number = p_version_number AND
51: IGS_PS_VER.course_status = IGS_PS_STAT.course_status;
52: BEGIN
53: p_message_name := null;
54: OPEN c_get_s_course_status;
55: FETCH c_get_s_course_status INTO v_s_course_status;