DBA Data[Home] [Help]

APPS.IGS_AD_GEN_006 dependencies on IGS_CA_INST

Line 63: igs_ca_inst ci1,

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
67: WHERE

Line 65: igs_ca_inst ci2,

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
67: WHERE
68: ppenqv.person_id = p_person_id AND
69: ci1.cal_type (+) = ppenqv.enq_acad_cal_type AND