APPS.IGS_EN_NSC_PKG dependencies on IGS_GR_STAT

Line 340: FROM igs_gr_graduand_all gr,igs_en_spa_awd_aim spaa, igs_gr_stat grs

336: )
337: OR
338: (cp_nslc_condition in( '2','3') AND l_grd_type = 'CONFERRAL_DATE' AND
339: (EXISTS (select gr.person_id
340: FROM igs_gr_graduand_all gr,igs_en_spa_awd_aim spaa, igs_gr_stat grs
341: WHERE gr.graduand_status =grs. graduand_status
342: AND grs. s_graduand_status = 'GRADUATED'
343: AND gr.person_id = spaa.person_id AND gr.course_cd = spaa.course_cd
344: AND spa.person_id = spaa.person_id

Line 1839: FROM igs_gr_stat

1835: WHERE gr.person_id = p_student_id
1836: AND gr.course_cd = p_course_cd
1837: AND gr. graduand_status IN
1838: ( SELECT graduand_status
1839: FROM igs_gr_stat
1840: WHERE s_graduand_status = 'GRADUATED'
1841: )
1842: AND gr.person_id = spaa.person_id AND gr.course_cd = spaa.course_cd AND gr.award_cd = spaa.award_cd
1843: AND spaa.conferral_date BETWEEN p_s_date AND p_e_date;

Line 1955: FROM igs_gr_graduand_all gr,igs_en_spa_awd_aim spaa, igs_gr_stat grs

1951: OR
1952: (cp_nslc_condition in( '2','3') AND
1953: ( cp_grad_type = 'CONFERRAL_DATE' AND
1954: (EXISTS (select gr.person_id
1955: FROM igs_gr_graduand_all gr,igs_en_spa_awd_aim spaa, igs_gr_stat grs
1956: WHERE gr.person_id = pr.person_id and
1957: gr.graduand_status =grs. graduand_status
1958: AND grs. s_graduand_status = 'GRADUATED'
1959: AND gr.person_id = spaa.person_id AND gr.course_cd = spaa.course_cd