APPS.IGS_EN_VAL_SUA dependencies on IGS_PE_PERSON

Line 2680: l_person_type igs_pe_person_types.person_type_code%TYPE;

2676: WHERE teach_cal_type = cp_teach_cal_type AND
2677: teach_ci_sequence_number = cp_teach_cal_seq_num ;
2678:
2679:
2680: l_person_type igs_pe_person_types.person_type_code%TYPE;
2681: l_enr_meth_type igs_en_method_type.enr_method_type%TYPE;
2682: l_enr_category VARCHAR2(20);
2683: l_enr_comm_type VARCHAR2(2000);
2684: l_enrolment_cat IGS_AS_SC_ATMPT_ENR.enrolment_cat%TYPE;

Line 3489: l_person_number IGS_PE_PERSON.person_number%TYPE;

3485: l_waitlist_ind VARCHAR2(1);
3486: l_return_status VARCHAR2(1);
3487: l_err_message VARCHAR2(1000);
3488: l_message_name VARCHAR2(1000);
3489: l_person_number IGS_PE_PERSON.person_number%TYPE;
3490: l_enroll BOOLEAN;
3491: BEGIN
3492: sub_stmt := 'SELECT uoo_id FROM IGS_PS_UNIT_OFR_OPT WHERE sup_uoo_id = :p_uoo_id AND
3493: relation_type = ''SUBORDINATE'' AND uoo_id in ('||p_enr_uoo_ids||')';