APPS.IGS_EN_GEN_015 dependencies on IGS_EN_STDNT_PS_ATT_ALL

Line 1631: l_attendance_type igs_en_stdnt_ps_att_all.attendance_type%TYPE;

1627:
1628: -- Local Variables
1629:
1630: l_achieved_cp NUMBER;
1631: l_attendance_type igs_en_stdnt_ps_att_all.attendance_type%TYPE;
1632: l_load_cal_type igs_ca_inst.cal_type%TYPE;
1633: l_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
1634: l_load_ci_alt_code igs_ca_inst.alternate_code%TYPE;
1635: l_load_ci_start_dt igs_ca_inst.start_dt%TYPE;

Line 1639: l_cmpl_dt igs_en_stdnt_ps_att_all.override_cmpl_dt%TYPE;

1635: l_load_ci_start_dt igs_ca_inst.start_dt%TYPE;
1636: l_load_ci_end_dt igs_ca_inst.end_dt%TYPE;
1637: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
1638: l_acad_ci_seq_num igs_ca_inst.sequence_number%TYPE;
1639: l_cmpl_dt igs_en_stdnt_ps_att_all.override_cmpl_dt%TYPE;
1640: l_init_dt DATE := NULL;
1641: l_init_load_cal_type igs_ca_inst.cal_type%TYPE;
1642: l_init_load_ci_seq_num igs_ca_inst.sequence_number%TYPE;
1643: l_init_load_ci_alt_code igs_ca_inst.alternate_code%TYPE;

Line 1664: FROM IGS_AS_SC_ATTEMPT_H scah1, IGS_EN_STDNT_PS_ATT_ALL SCA1

1660: -- Cursor find the Date at which the Student Program Attempt became 'ACTIVE'
1661: CURSOR cur_sca_active_dt( p_person_id igs_as_sc_attempt_h_all.person_id%TYPE,
1662: p_course_cd igs_as_sc_attempt_h_all.course_cd%TYPE ) IS
1663: SELECT NVL(SCAH1.hist_start_dt,SCA1.last_update_date) hist_start_dt
1664: FROM IGS_AS_SC_ATTEMPT_H scah1, IGS_EN_STDNT_PS_ATT_ALL SCA1
1665: WHERE SCA1.person_id = SCAH1.person_id(+)
1666: AND SCA1.course_cd = SCAH1.course_cd(+)
1667: AND SCA1.person_id = p_person_id
1668: AND SCA1.course_cd = p_course_cd