APPS.IGF_AP_OSS_INTR_DTLS dependencies on IGS_EN_STDNT_PS_ATT

Line 111: -- Cursor to get details enrolment details from igs_en_stdnt_ps_att

107: -- [
108: -- start of declaration of variables for get_enrol_details
109:
110: --
111: -- Cursor to get details enrolment details from igs_en_stdnt_ps_att
112: --
113:
114: --Added the last two AND conditions as per the FACCR004 in Disbursement Build Jul 2002
115: --to differentiate between records having primary program as 'Y' and 'A' or 'E'

Line 117: CURSOR enrl_std_cur( p_person_id igs_en_stdnt_ps_att_all.person_id%TYPE) IS

113:
114: --Added the last two AND conditions as per the FACCR004 in Disbursement Build Jul 2002
115: --to differentiate between records having primary program as 'Y' and 'A' or 'E'
116: --Bug Id:2154941
117: CURSOR enrl_std_cur( p_person_id igs_en_stdnt_ps_att_all.person_id%TYPE) IS
118: SELECT course_cd, adm_admission_appl_number, version_number, commencement_dt, course_attempt_status, attendance_mode, location_cd
119: FROM igs_en_stdnt_ps_att
120: WHERE person_id = p_person_id
121: AND key_program = 'Y' ;

Line 119: FROM igs_en_stdnt_ps_att

115: --to differentiate between records having primary program as 'Y' and 'A' or 'E'
116: --Bug Id:2154941
117: CURSOR enrl_std_cur( p_person_id igs_en_stdnt_ps_att_all.person_id%TYPE) IS
118: SELECT course_cd, adm_admission_appl_number, version_number, commencement_dt, course_attempt_status, attendance_mode, location_cd
119: FROM igs_en_stdnt_ps_att
120: WHERE person_id = p_person_id
121: AND key_program = 'Y' ;
122:
123:

Line 129: FROM igs_en_stdnt_ps_att

125: --Cursor to check if there are more than 1 program attempt for a person.
126: --
127: CURSOR cur_get_no_of_prg_attempts IS
128: SELECT COUNT(person_id)
129: FROM igs_en_stdnt_ps_att
130: WHERE person_id = p_person_id;
131:
132: --Added the cursor to resolve bug 2296776
133:

Line 145: FROM igs_ad_ps_appl_inst adps,igs_en_stdnt_ps_att enps,

141:
142: CURSOR get_adm_dtls(cp_course_cd igs_ps_ver.course_cd%TYPE) IS
143: SELECT adm.course_type adm_course_type,adps.course_cd adm_course_cd,
144: adps.admission_appl_number adm_appl_number
145: FROM igs_ad_ps_appl_inst adps,igs_en_stdnt_ps_att enps,
146: igs_ps_ver adm,igs_ps_ver enrl
147: WHERE adps.person_id=p_person_id AND adps.person_id= enps.person_id
148: AND enps.course_cd=cp_course_cd AND enps.course_cd=enrl.course_cd
149: AND adps.course_cd = adm.course_cd AND adm.course_type=enrl.course_type;

Line 162: -- igs_en_stdnt_ps_att.If there are more than one records then

158: enrl_std_mult_rec enrl_std_cur%ROWTYPE;
159:
160: --
161: -- This cursor will also determine if there are more than one records for a person in
162: -- igs_en_stdnt_ps_att.If there are more than one records then
163: -- multiple_prog_d = 'Y' else 'N'
164: --
165: lv_mult_prog_d VARCHAR2(10) DEFAULT 'N';
166:

Line 226: -- IGS_EN_STDNT_PS_ATT.COURSE_CD IGS_EN_STDNT_PS_ATT.VERSION_NUMBER

222:
223: en_std_rec en_std_cur%ROWTYPE;
224:
225: -- The above COURSE_CD and VERSION_NUMBER are the Program details from Enrollment Module i.e.
226: -- IGS_EN_STDNT_PS_ATT.COURSE_CD IGS_EN_STDNT_PS_ATT.VERSION_NUMBER
227: --
228:
229: -- end of declaration of variables for get_enrl_details
230: -- ]

Line 300: igs_en_stdnt_ps_att_all ps

296: SELECT susa.unit_set_cd,susa.course_cd,susa.us_version_number
297: FROM igs_as_su_setatmpt susa,
298: igs_en_unit_set us ,
299: igs_en_unit_set_cat usc,
300: igs_en_stdnt_ps_att_all ps
301: WHERE susa.person_id = cp_person_id
302: AND ps.person_id = susa.person_id
303: AND susa.course_cd = ps.course_cd
304: AND ps.key_program = 'Y'

Line 441: -- Get enrol related fields (IGS_EN_STDNT_PS_ATT )

437:
438:
439:
440:
441: -- Get enrol related fields (IGS_EN_STDNT_PS_ATT )
442:
443: OPEN resp_org_unit_cur(enrl_std_rec.course_cd,
444: enrl_std_rec.version_number);
445: FETCH resp_org_unit_cur INTO org_unit_rec;