APPS.IGF_AP_GEN_001 dependencies on IGS_EN_STDNT_PS_ATT_ALL

Line 24: FROM igs_en_stdnt_ps_att_all

20: */
21: CURSOR c_comm_date(cp_person_id hz_parties.party_id%TYPE, cp_course_cd igs_ps_ver_all.course_cd%TYPE,
22: cp_version_number igs_ps_ver_all.version_number%TYPE)IS
23: SELECT commencement_dt
24: FROM igs_en_stdnt_ps_att_all
25: WHERE course_cd = cp_course_cd
26: AND version_number = cp_version_number
27: AND person_id = cp_person_id;
28: l_comm_date c_comm_date%ROWTYPE;

Line 64: FROM igs_en_stdnt_ps_att_all

60: -- Get the details of the Key Program
61: CURSOR key_program_dtl_cur(cp_person_id hz_parties.party_id%TYPE, cp_course_cd igs_ps_ver_all.course_cd%TYPE,
62: cp_version_number igs_ps_ver_all.version_number%TYPE) IS
63: SELECT course_cd, version_number, cal_type, location_cd, attendance_mode, attendance_type
64: FROM igs_en_stdnt_ps_att_all
65: WHERE course_cd = cp_course_cd
66: AND version_number = cp_version_number
67: AND person_id = cp_person_id;
68: