APPS.IGS_AS_SS_DOC_REQUEST dependencies on IGS_PE_PERSON

Line 590: cp_person_id igs_pe_person.person_id%TYPE,

586: --
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,

Line 604: cp_person_id igs_pe_person.person_id%TYPE,

600: AND spa.course_attempt_status <> 'UNCONFIRM'
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,

Line 940: FROM igs_pe_person_types typ,

936: -- former student
937: --
938: CURSOR cur_student_type (cp_person_id IN NUMBER) IS
939: SELECT 'Y' current_student
940: FROM igs_pe_person_types typ,
941: igs_pe_typ_instances_all inst
942: WHERE inst.person_id = cp_person_id
943: AND inst.person_type_code = typ.person_type_code
944: AND typ.system_type = 'STUDENT'