APPS.IGS_PR_GEN_004 dependencies on IGS_EN_STDNT_PS_ATT_ALL

Line 2884: n_person_id igs_en_stdnt_ps_att_all.person_id%TYPE;

2880: AND scae.ci_sequence_number = ci.sequence_number
2881: ORDER BY ci.end_dt DESC;
2882: --
2883: rec_enr_cat cur_enr_cat%ROWTYPE;
2884: n_person_id igs_en_stdnt_ps_att_all.person_id%TYPE;
2885: v_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;
2886: n_version_number igs_en_stdnt_ps_att_all.version_number%TYPE;
2887: process_record BOOLEAN := TRUE;
2888: --

Line 2885: v_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;

2881: ORDER BY ci.end_dt DESC;
2882: --
2883: rec_enr_cat cur_enr_cat%ROWTYPE;
2884: n_person_id igs_en_stdnt_ps_att_all.person_id%TYPE;
2885: v_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;
2886: n_version_number igs_en_stdnt_ps_att_all.version_number%TYPE;
2887: process_record BOOLEAN := TRUE;
2888: --
2889: BEGIN

Line 2886: n_version_number igs_en_stdnt_ps_att_all.version_number%TYPE;

2882: --
2883: rec_enr_cat cur_enr_cat%ROWTYPE;
2884: n_person_id igs_en_stdnt_ps_att_all.person_id%TYPE;
2885: v_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;
2886: n_version_number igs_en_stdnt_ps_att_all.version_number%TYPE;
2887: process_record BOOLEAN := TRUE;
2888: --
2889: BEGIN
2890: --

Line 2891: from_clause := from_clause || 'FROM igs_en_stdnt_ps_att_all sca, igs_en_su_attempt_all sua, igs_ca_inst_rel cir';

2887: process_record BOOLEAN := TRUE;
2888: --
2889: BEGIN
2890: --
2891: from_clause := from_clause || 'FROM igs_en_stdnt_ps_att_all sca, igs_en_su_attempt_all sua, igs_ca_inst_rel cir';
2892: --
2893: -- Append Person ID Group filter to the Where clause only when it is passed
2894: --
2895: IF (p_group_id IS NOT NULL) THEN