APPS.IGS_AD_GEN_006 dependencies on IGS_PE_PERSON

Line 53: CURSOR c_ppenqv (p_person_id IN IGS_PE_PERSON.person_id%TYPE) IS

49: IS
50: BEGIN -- admp_get_enq_pp
51: -- Routine to get the admission enquiry person preferences
52: DECLARE
53: CURSOR c_ppenqv (p_person_id IN IGS_PE_PERSON.person_id%TYPE) IS
54: SELECT ppenqv.enq_acad_cal_type,
55: ppenqv.enq_acad_ci_sequence_number,
56: ppenqv.enq_acad_alternate_code,
57: cat1.abbreviation,

Line 62: FROM igs_pe_person_prefs_enq_v ppenqv, /* Removed cartesian join with IGS_PE_PERSON. Bug 3150054 */

58: ppenqv.enq_adm_cal_type,
59: ppenqv.enq_adm_ci_sequence_number,
60: ppenqv.enq_adm_alternate_code,
61: cat2.abbreviation
62: FROM igs_pe_person_prefs_enq_v ppenqv, /* Removed cartesian join with IGS_PE_PERSON. Bug 3150054 */
63: igs_ca_inst ci1,
64: igs_ca_type cat1,
65: igs_ca_inst ci2,
66: igs_ca_type cat2

Line 76: v_person_id IGS_PE_PERSON.PERSON_ID%TYPE;

72: ci2.cal_type (+) = ppenqv.enq_adm_cal_type AND
73: ci2.sequence_number (+) = ppenqv.enq_adm_ci_sequence_number AND
74: cat2.cal_type (+) = ci2.cal_type;
75:
76: v_person_id IGS_PE_PERSON.PERSON_ID%TYPE;
77: BEGIN
78: v_person_id := FND_GLOBAL.USER_ID;
79: OPEN c_ppenqv(v_person_id);
80: FETCH c_ppenqv INTO p_enq_acad_cal_type,