APPS.IGS_ST_GEN_001 dependencies on IGS_PS_AWARD

Line 494: FROM IGS_PS_AWARD caw

490: BEGIN
491: DECLARE
492: CURSOR c_caw IS
493: SELECT 'x'
494: FROM IGS_PS_AWARD caw
495: WHERE caw.course_cd = p_course_cd AND
496: caw.version_number = p_version_number AND
497: caw.closed_ind = 'N' AND
498: EXISTS (SELECT 'x'

Line 499: FROM IGS_PS_AWARD caw1

495: WHERE caw.course_cd = p_course_cd AND
496: caw.version_number = p_version_number AND
497: caw.closed_ind = 'N' AND
498: EXISTS (SELECT 'x'
499: FROM IGS_PS_AWARD caw1
500: WHERE caw1.course_cd = p_prev_course_cd AND
501: caw1.version_number = p_prev_version_number AND
502: caw1.award_cd <> caw.award_cd AND
503: caw1.closed_ind = 'N');