APPS.IGS_AS_SS_DOC_REQUEST dependencies on IGS_EN_STDNT_PS_ATT_ALL

Line 594: FROM igs_en_stdnt_ps_att_all spa,

590: cp_person_id igs_pe_person.person_id%TYPE,
591: cp_course_type igs_ps_type.course_type%TYPE
592: ) IS
593: SELECT spa.commencement_dt
594: FROM igs_en_stdnt_ps_att_all spa,
595: igs_ps_ver_all pv
596: WHERE spa.person_id = cp_person_id
597: AND pv.course_type = cp_course_type
598: AND spa.course_cd = pv.course_cd

Line 608: FROM igs_en_stdnt_ps_att_all spa,

604: cp_person_id igs_pe_person.person_id%TYPE,
605: cp_course_type igs_ps_type.course_type%TYPE
606: ) IS
607: SELECT spa.course_rqrmnts_complete_dt
608: FROM igs_en_stdnt_ps_att_all spa,
609: igs_ps_ver_all pv
610: WHERE spa.person_id = cp_person_id
611: AND pv.course_type = cp_course_type
612: AND spa.course_cd = pv.course_cd

Line 616: v_commencement_dt igs_en_stdnt_ps_att_all.commencement_dt%TYPE;

612: AND spa.course_cd = pv.course_cd
613: AND spa.version_number = pv.version_number
614: AND spa.course_attempt_status IN ('ENROLLED', 'COMPLETED')
615: ORDER BY spa.course_rqrmnts_complete_dt DESC;
616: v_commencement_dt igs_en_stdnt_ps_att_all.commencement_dt%TYPE;
617: v_course_rqrmnts_complete_dt igs_en_stdnt_ps_att_all.course_rqrmnts_complete_dt%TYPE;
618: BEGIN
619: /* This function will return the earliest commencement date and the latest
620: course requirements completion date of the particular student in a particular

Line 617: v_course_rqrmnts_complete_dt igs_en_stdnt_ps_att_all.course_rqrmnts_complete_dt%TYPE;

613: AND spa.version_number = pv.version_number
614: AND spa.course_attempt_status IN ('ENROLLED', 'COMPLETED')
615: ORDER BY spa.course_rqrmnts_complete_dt DESC;
616: v_commencement_dt igs_en_stdnt_ps_att_all.commencement_dt%TYPE;
617: v_course_rqrmnts_complete_dt igs_en_stdnt_ps_att_all.course_rqrmnts_complete_dt%TYPE;
618: BEGIN
619: /* This function will return the earliest commencement date and the latest
620: course requirements completion date of the particular student in a particular
621: career passed as parameter