APPS.IGS_PS_VAL_CRS dependencies on IGS_PS_STAT

Line 11: v_s_course_status IGS_PS_STAT.s_course_status%TYPE;

7: p_course_cd IN VARCHAR2 ,
8: p_version_number IN NUMBER ,
9: p_message_name OUT NOCOPY VARCHAR2 )
10: RETURN BOOLEAN AS
11: v_s_course_status IGS_PS_STAT.s_course_status%TYPE;
12: CURSOR c_get_s_course_status IS
13: SELECT s_course_status
14: FROM IGS_PS_VER,
15: IGS_PS_STAT

Line 15: IGS_PS_STAT

11: v_s_course_status IGS_PS_STAT.s_course_status%TYPE;
12: CURSOR c_get_s_course_status IS
13: SELECT s_course_status
14: FROM IGS_PS_VER,
15: IGS_PS_STAT
16: WHERE course_cd = p_course_cd AND
17: version_number = p_version_number AND
18: IGS_PS_VER.course_status = IGS_PS_STAT.course_status;
19: BEGIN

Line 18: IGS_PS_VER.course_status = IGS_PS_STAT.course_status;

14: FROM IGS_PS_VER,
15: IGS_PS_STAT
16: WHERE course_cd = p_course_cd AND
17: version_number = p_version_number AND
18: IGS_PS_VER.course_status = IGS_PS_STAT.course_status;
19: BEGIN
20: -- Validate the IGS_PS_COURSE version system status to determine if
21: -- updates or inserts can be made to IGS_PS_COURSE detail records.
22: p_message_name := NULL;