APPS.IGS_AS_PROD_DOC dependencies on IGS_AS_CHN_GRD_REQ

Line 113: CURSOR cur_hold_eft (cp_person_id igs_as_chn_grd_req.person_id%TYPE,

109: rec_cur_hold_dlv_ind cur_hold_dlv_ind%ROWTYPE;
110:
111: -- To determine if the student has a pending transcript hold.
112: --ijeddy, bug 3410409.
113: CURSOR cur_hold_eft (cp_person_id igs_as_chn_grd_req.person_id%TYPE,
114: cp_creation_date igs_as_ord_itm_int.creation_date%TYPE) IS
115: SELECT 'X'
116: FROM igs_pe_persenc_effct
117: WHERE person_id = cp_person_id AND

Line 155: CURSOR cur_chn_grd_req (cp_person_id igs_as_chn_grd_req.person_id%TYPE,

151: finalised_outcome_ind = 'Y';
152: rec_cur_as_suaoa cur_as_suaoa%ROWTYPE;
153:
154: -- Cursor to check if the user has requested to 'Hold for Grade Change'.
155: CURSOR cur_chn_grd_req (cp_person_id igs_as_chn_grd_req.person_id%TYPE,
156: cp_creation_date igs_as_ord_itm_int.creation_date%TYPE)IS
157: SELECT 'X'
158: FROM igs_as_chn_grd_req
159: WHERE person_id = cp_person_id AND

Line 158: FROM igs_as_chn_grd_req

154: -- Cursor to check if the user has requested to 'Hold for Grade Change'.
155: CURSOR cur_chn_grd_req (cp_person_id igs_as_chn_grd_req.person_id%TYPE,
156: cp_creation_date igs_as_ord_itm_int.creation_date%TYPE)IS
157: SELECT 'X'
158: FROM igs_as_chn_grd_req
159: WHERE person_id = cp_person_id AND
160: current_status = cst_in_progress AND
161: request_date < cp_creation_date;
162: rec_cur_chn_grd_req cur_chn_grd_req%ROWTYPE;

Line 165: CURSOR cur_ps_att (cp_person_id igs_as_chn_grd_req.person_id%TYPE,

161: request_date < cp_creation_date;
162: rec_cur_chn_grd_req cur_chn_grd_req%ROWTYPE;
163:
164: -- For Program centric Mode- Check if the program attempt status is 'COMPLETED' (for all the programs if program is not selected).
165: CURSOR cur_ps_att (cp_person_id igs_as_chn_grd_req.person_id%TYPE,
166: cp_creation_date igs_as_ord_itm_int.creation_date%TYPE,
167: cp_course_cd igs_en_sca_v.course_cd%TYPE)IS
168: SELECT 'X'
169: FROM igs_en_stdnt_ps_att_all

Line 176: CURSOR cur_en_sca (cp_person_id igs_as_chn_grd_req.person_id%TYPE,

172: TRUNC(course_rqrmnts_complete_dt) BETWEEN TRUNC(igs_ge_date.igsdate(cp_creation_date)) AND TRUNC(SYSDATE);
173: rec_cur_ps_att cur_ps_att%ROWTYPE;
174:
175: -- For Career centric Mode- Check if the program attempt status is 'COMPLETED' (under all the career if career is not selected).
176: CURSOR cur_en_sca (cp_person_id igs_as_chn_grd_req.person_id%TYPE,
177: cp_creation_date igs_as_ord_itm_int.creation_date%TYPE,
178: cp_course_type igs_en_sca_v.course_type%TYPE)IS
179: SELECT 'X'
180: FROM igs_en_sca_v