APPS.IGS_RATINGS_PUB dependencies on IGS_AD_PS_APPL_INST

Line 284: FROM igs_ad_ps_appl_inst a

280:
281:
282: CURSOR c_aplinst_cur IS
283: SELECT a.ROWID, a.*
284: FROM igs_ad_ps_appl_inst a
285: WHERE person_id = p_person_id
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;

Line 332: igs_ad_ps_appl_inst apl, /* Replaced igs_ad_ps_appl_inst_aplinst_v with igs_ad_ps_appl_inst Bug 3150054 */

328: IS
329: SELECT
330: doc.s_adm_doc_status
331: FROM
332: igs_ad_ps_appl_inst apl, /* Replaced igs_ad_ps_appl_inst_aplinst_v with igs_ad_ps_appl_inst Bug 3150054 */
333: igs_ad_doc_stat doc
334: WHERE person_id = l_person_id
335: AND admission_appl_number = l_adm_apl_num
336: AND nominated_course_cd = l_nom_crs_cd

Line 340: l_adm_doc igs_ad_ps_appl_inst.adm_doc_status%TYPE;

336: AND nominated_course_cd = l_nom_crs_cd
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;