APPS.IGS_EN_NSC_PKG dependencies on IGS_EN_SPA_AWD_AIM

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 1834: FROM igs_gr_graduand_all gr,igs_en_spa_awd_aim spaa

1830: /* For getting conferral date */
1831:
1832: CURSOR c_conferral_dt(p_course_cd VARCHAR,p_s_date DATE,p_e_date DATE) IS
1833: SELECT spaa.conferral_date
1834: FROM igs_gr_graduand_all gr,igs_en_spa_awd_aim spaa
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

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