APPS.IGS_RE_GEN_001 dependencies on IGS_EN_STDNT_PS_INTM

Line 1047: v_sci_end_dt IGS_EN_STDNT_PS_INTM.end_dt%TYPE;

1043: v_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
1044: v_today_dt DATE;
1045: v_EFTD_total NUMBER;
1046: v_next_rec_flg BOOLEAN;
1047: v_sci_end_dt IGS_EN_STDNT_PS_INTM.end_dt%TYPE;
1048: v_end_dt IGS_EN_STDNT_PS_INTM.end_dt%TYPE;
1049: CURSOR c_ca IS
1050: SELECT ca.sequence_number,
1051: ca.attendance_percentage

Line 1048: v_end_dt IGS_EN_STDNT_PS_INTM.end_dt%TYPE;

1044: v_today_dt DATE;
1045: v_EFTD_total NUMBER;
1046: v_next_rec_flg BOOLEAN;
1047: v_sci_end_dt IGS_EN_STDNT_PS_INTM.end_dt%TYPE;
1048: v_end_dt IGS_EN_STDNT_PS_INTM.end_dt%TYPE;
1049: CURSOR c_ca IS
1050: SELECT ca.sequence_number,
1051: ca.attendance_percentage
1052: FROM IGS_RE_CANDIDATURE ca

Line 1091: FROM IGS_EN_STDNT_PS_INTM sci,

1087: crv.version_number = cp_version_number;
1088: CURSOR c_sci IS
1089: SELECT sci.start_dt,
1090: sci.end_dt
1091: FROM IGS_EN_STDNT_PS_INTM sci,
1092: IGS_EN_INTM_TYPES eit
1093: WHERE sci.person_id = p_person_id AND
1094: sci.course_cd = p_course_cd AND
1095: sci.approved = eit.appr_reqd_ind AND

Line 1101: cp_sci_end_dt IGS_EN_STDNT_PS_INTM.end_dt%TYPE,

1097: sci.logical_delete_date = TO_DATE('31-12-4712','DD-MM-YYYY')
1098: ORDER BY sci.start_dt;
1099: CURSOR c_cah2 (
1100: cp_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE,
1101: cp_sci_end_dt IGS_EN_STDNT_PS_INTM.end_dt%TYPE,
1102: cp_sci_start_dt IGS_EN_STDNT_PS_INTM.start_dt%TYPE) IS
1103: SELECT cah.hist_start_dt,
1104: cah.hist_end_dt,
1105: cah.attendance_percentage

Line 1102: cp_sci_start_dt IGS_EN_STDNT_PS_INTM.start_dt%TYPE) IS

1098: ORDER BY sci.start_dt;
1099: CURSOR c_cah2 (
1100: cp_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE,
1101: cp_sci_end_dt IGS_EN_STDNT_PS_INTM.end_dt%TYPE,
1102: cp_sci_start_dt IGS_EN_STDNT_PS_INTM.start_dt%TYPE) IS
1103: SELECT cah.hist_start_dt,
1104: cah.hist_end_dt,
1105: cah.attendance_percentage
1106: FROM IGS_RE_CDT_ATT_HIST cah