APPS.IGS_RATINGS_PUB dependencies on IGS_AD_APPL_EVAL_V

Line 310: l_person_id igs_ad_appl_eval_v.person_id%TYPE,

306: AND nominated_course_cd = l_nom_crs_cd
307: AND sequence_number = l_seq_num ;
308:
309: CURSOR get_rating_cur(
310: l_person_id igs_ad_appl_eval_v.person_id%TYPE,
311: l_adm_apl_num igs_ad_appl_eval_v.admission_appl_number%TYPE,
312: l_nom_crs_cd igs_ad_appl_eval_v.nominated_course_cd%TYPE,
313: l_seq_num igs_ad_appl_eval_v.sequence_number%TYPE
314: ) IS

Line 311: l_adm_apl_num igs_ad_appl_eval_v.admission_appl_number%TYPE,

307: AND sequence_number = l_seq_num ;
308:
309: CURSOR get_rating_cur(
310: l_person_id igs_ad_appl_eval_v.person_id%TYPE,
311: l_adm_apl_num igs_ad_appl_eval_v.admission_appl_number%TYPE,
312: l_nom_crs_cd igs_ad_appl_eval_v.nominated_course_cd%TYPE,
313: l_seq_num igs_ad_appl_eval_v.sequence_number%TYPE
314: ) IS
315: SELECT rating

Line 312: l_nom_crs_cd igs_ad_appl_eval_v.nominated_course_cd%TYPE,

308:
309: CURSOR get_rating_cur(
310: l_person_id igs_ad_appl_eval_v.person_id%TYPE,
311: l_adm_apl_num igs_ad_appl_eval_v.admission_appl_number%TYPE,
312: l_nom_crs_cd igs_ad_appl_eval_v.nominated_course_cd%TYPE,
313: l_seq_num igs_ad_appl_eval_v.sequence_number%TYPE
314: ) IS
315: SELECT rating
316: FROM igs_ad_appl_eval_v

Line 313: l_seq_num igs_ad_appl_eval_v.sequence_number%TYPE

309: CURSOR get_rating_cur(
310: l_person_id igs_ad_appl_eval_v.person_id%TYPE,
311: l_adm_apl_num igs_ad_appl_eval_v.admission_appl_number%TYPE,
312: l_nom_crs_cd igs_ad_appl_eval_v.nominated_course_cd%TYPE,
313: l_seq_num igs_ad_appl_eval_v.sequence_number%TYPE
314: ) IS
315: SELECT rating
316: FROM igs_ad_appl_eval_v
317: WHERE person_id = l_person_id

Line 316: FROM igs_ad_appl_eval_v

312: l_nom_crs_cd igs_ad_appl_eval_v.nominated_course_cd%TYPE,
313: l_seq_num igs_ad_appl_eval_v.sequence_number%TYPE
314: ) IS
315: SELECT rating
316: FROM igs_ad_appl_eval_v
317: WHERE person_id = l_person_id
318: AND admission_appl_number = l_adm_apl_num
319: AND nominated_course_cd = l_nom_crs_cd
320: AND sequence_number = l_seq_num

Line 341: l_rating igs_ad_appl_eval_v.rating%TYPE;

337: AND sequence_number = l_seq_number
338: AND doc.adm_doc_status = apl.adm_doc_status;
339:
340: l_adm_doc igs_ad_ps_appl_inst.adm_doc_status%TYPE;
341: l_rating igs_ad_appl_eval_v.rating%TYPE;
342: l_exist_arp igs_ad_appl_arp_v%ROWTYPE;
343: l_modif_eval_type igs_ad_apl_rev_prf_all.sequential_concurrent_ind%TYPE;
344: l_exist_eval_type igs_ad_apl_rev_prf_all.sequential_concurrent_ind%TYPE;
345: l_get_current_eval VARCHAR2(1);