APPS.IGS_RATINGS_PUB dependencies on IGS_AD_APL_REV_PRF_ALL

Line 290: CURSOR eval_type_cur( l_appl_rev_profile_id igs_ad_apl_rev_prf_all.appl_rev_profile_id%TYPE)

286: AND admission_appl_number = p_admission_appl_number
287: AND nominated_course_cd = p_nominated_program_cd
288: AND sequence_number = p_sequence_number;
289:
290: CURSOR eval_type_cur( l_appl_rev_profile_id igs_ad_apl_rev_prf_all.appl_rev_profile_id%TYPE)
291: IS
292: SELECT distinct sequential_concurrent_ind
293: FROM igs_ad_apl_rev_prf_all
294: WHERE appl_rev_profile_id = l_appl_rev_profile_id;

Line 293: FROM igs_ad_apl_rev_prf_all

289:
290: CURSOR eval_type_cur( l_appl_rev_profile_id igs_ad_apl_rev_prf_all.appl_rev_profile_id%TYPE)
291: IS
292: SELECT distinct sequential_concurrent_ind
293: FROM igs_ad_apl_rev_prf_all
294: WHERE appl_rev_profile_id = l_appl_rev_profile_id;
295:
296: CURSOR c_get_appl_rev_profile_id (
297: l_person_id igs_ad_appl_arp.person_id%TYPE,

Line 343: l_modif_eval_type igs_ad_apl_rev_prf_all.sequential_concurrent_ind%TYPE;

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);
346: l_c_aplinst_cur c_aplinst_cur%ROWTYPE;
347: l_api_version CONSTANT NUMBER := 1.0;

Line 344: l_exist_eval_type igs_ad_apl_rev_prf_all.sequential_concurrent_ind%TYPE;

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);
346: l_c_aplinst_cur c_aplinst_cur%ROWTYPE;
347: l_api_version CONSTANT NUMBER := 1.0;
348: l_api_name CONSTANT VARCHAR2(30) := 'ASSIGN_EVALUATORS_TO_AI';