APPS.IGF_AP_GEN_001 dependencies on IGS_EN_STDNT_PS_ATT

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:

Line 99: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,

95: x_course_cd igs_ps_ver_all.course_cd%TYPE;
96: x_version_number igs_ps_ver_all.version_number%TYPE;
97:
98: CURSOR c_spa( cp_person_id hz_parties.party_id%TYPE,
99: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
100: cp_version_number igs_en_stdnt_ps_att.version_number%TYPE
101: )IS
102: SELECT commencement_dt
103: FROM igs_en_stdnt_ps_att

Line 100: cp_version_number igs_en_stdnt_ps_att.version_number%TYPE

96: x_version_number igs_ps_ver_all.version_number%TYPE;
97:
98: CURSOR c_spa( cp_person_id hz_parties.party_id%TYPE,
99: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
100: cp_version_number igs_en_stdnt_ps_att.version_number%TYPE
101: )IS
102: SELECT commencement_dt
103: FROM igs_en_stdnt_ps_att
104: WHERE person_id = cp_person_id

Line 103: FROM igs_en_stdnt_ps_att

99: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
100: cp_version_number igs_en_stdnt_ps_att.version_number%TYPE
101: )IS
102: SELECT commencement_dt
103: FROM igs_en_stdnt_ps_att
104: WHERE person_id = cp_person_id
105: AND COURSE_CD = cp_course_cd
106: AND VERSION_NUMBER = cp_version_number;
107:

Line 371: FROM igs_en_stdnt_ps_att

367: l_term_rec c_ld_calendars_start%ROWTYPE;
368:
369: CURSOR c_spa( cp_person_id hz_parties.party_id%TYPE)IS
370: SELECT *
371: FROM igs_en_stdnt_ps_att
372: WHERE person_id = cp_person_id
373: AND key_program = 'Y';
374: l_spa_rec C_SPA%ROWTYPE;
375: