APPS.IGS_AS_SS_DOC_REQUEST dependencies on IGS_PS_TYPE

Line 591: cp_course_type igs_ps_type.course_type%TYPE

587: FUNCTION enrp_get_career_dates (p_person_id IN NUMBER, p_course_type IN VARCHAR2)
588: RETURN VARCHAR2 AS
589: CURSOR c_comm_dt (
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

Line 605: cp_course_type igs_ps_type.course_type%TYPE

601: AND spa.commencement_dt IS NOT NULL
602: ORDER BY spa.commencement_dt ASC;
603: CURSOR c_cmpl_dt (
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