APPS.IGS_IN_GEN_001 dependencies on IGS_AS_SC_ATMPT_ENR

Line 590: v_enrolment_cat IGS_AS_SC_ATMPT_ENR.enrolment_cat%TYPE;

586: AS
587: gv_other_detail VARCHAR2(255);
588: BEGIN -- inqp_get_enr_cat
589: DECLARE
590: v_enrolment_cat IGS_AS_SC_ATMPT_ENR.enrolment_cat%TYPE;
591: v_description IGS_EN_ENROLMENT_CAT.description%TYPE;
592: CURSOR c_scae IS
593: SELECT scae.enrolment_cat,
594: ec.description

Line 595: FROM IGS_AS_SC_ATMPT_ENR scae,

591: v_description IGS_EN_ENROLMENT_CAT.description%TYPE;
592: CURSOR c_scae IS
593: SELECT scae.enrolment_cat,
594: ec.description
595: FROM IGS_AS_SC_ATMPT_ENR scae,
596: IGS_CA_INST ci,
597: IGS_EN_ENROLMENT_CAT ec
598: WHERE scae.person_id = p_person_id AND
599: scae.course_cd =p_course_cd AND