APPS.IGS_UC_EXP_QUAL_SUM_IMP_PKG dependencies on IGS_UC_APPLICANTS

Line 31: FROM igs_uc_applicants ucap

27: SELECT ucap.exam_change_date, ucap.a_levels, ucap.as_levels, ucap.winter,
28: ucap.btec, ucap.ilc, ucap.ailc, ucap.ib, ucap.manual, ucap.oeq,
29: ucap.roa, ucap.oss_person_id, ucap.GCE, ucap.VCE, ucap.SQA,ucap.previous,
30: ucap.previousas, ucap.keyskills, ucap.vocational, ucap.prevoeq
31: FROM igs_uc_applicants ucap
32: WHERE ucap.oss_person_id IS NOT NULL;
33:
34: CURSOR c2(l_oss_person_id igs_uc_applicants.oss_person_id%TYPE) IS
35: SELECT uexq.exp_qual_sum_id, uexq.person_id, uexq.seq_updated_date,

Line 34: CURSOR c2(l_oss_person_id igs_uc_applicants.oss_person_id%TYPE) IS

30: ucap.previousas, ucap.keyskills, ucap.vocational, ucap.prevoeq
31: FROM igs_uc_applicants ucap
32: WHERE ucap.oss_person_id IS NOT NULL;
33:
34: CURSOR c2(l_oss_person_id igs_uc_applicants.oss_person_id%TYPE) IS
35: SELECT uexq.exp_qual_sum_id, uexq.person_id, uexq.seq_updated_date,
36: uexq.rowid, uexq.exp_gce, uexq.exp_vce, uexq.winter_a_levels,
37: uexq.prev_a_levels, uexq.prev_as_levels, uexq.sqa, uexq.btec,
38: uexq.ib, uexq.ilc, uexq.ailc, uexq.ksi, uexq.roa, uexq.manual,