APPS.IGS_PS_VAL_CTY dependencies on IGS_PS_AWARD

Line 93: IGS_PS_AWARD ca

89: v_check CHAR;
90: CURSOR c_sel_course_award IS
91: SELECT 'x'
92: FROM IGS_PS_VER cv,
93: IGS_PS_AWARD ca
94: WHERE course_type = p_course_type AND
95: cv.course_cd = ca.course_cd AND
96: cv.version_number = ca.version_number AND
97: ca.closed_ind = 'N';

Line 102: -- no IGS_PS_AWARD record should exist for

98: BEGIN
99: IF (p_award_course_ind = 'N') THEN
100: OPEN c_sel_course_award;
101: FETCH c_sel_course_award INTO v_check;
102: -- no IGS_PS_AWARD record should exist for
103: -- IGS_PS_VER that have current IGS_PS_TYPE
104: IF c_sel_course_award%FOUND THEN
105: CLOSE c_sel_course_award;
106: p_message_name := 'IGS_PS_AWARD_PRG_NOTSET_N';

Line 106: p_message_name := 'IGS_PS_AWARD_PRG_NOTSET_N';

102: -- no IGS_PS_AWARD record should exist for
103: -- IGS_PS_VER that have current IGS_PS_TYPE
104: IF c_sel_course_award%FOUND THEN
105: CLOSE c_sel_course_award;
106: p_message_name := 'IGS_PS_AWARD_PRG_NOTSET_N';
107: RETURN FALSE;
108: END IF;
109: CLOSE c_sel_course_award;
110: END IF;