DBA Data[Home] [Help]

APPS.IGS_EN_GEN_002 dependencies on IGS_AS_SC_ATMPT_ENR

Line 364: FROM IGS_AS_SC_ATMPT_ENR scae,

360: v_aa_rec c_aa%ROWTYPE;
361: CURSOR c_scae_cir_ci_cat IS
362: SELECT cir.sup_cal_type,
363: cir.sup_ci_sequence_number
364: FROM IGS_AS_SC_ATMPT_ENR scae,
365: IGS_CA_INST_REL cir,
366: IGS_CA_INST ci,
367: IGS_CA_TYPE cat
368: WHERE scae.person_id = p_person_id AND

Line 762: FROM IGS_AS_SC_ATMPT_ENR scae

758: ca.sca_course_cd = p_course_cd;
759: CURSOR c_scae
760: IS
761: SELECT 'x'
762: FROM IGS_AS_SC_ATMPT_ENR scae
763: WHERE scae.person_id = p_person_id AND
764: scae.course_cd = p_course_cd AND
765: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(
766: p_acad_cal_type,