APPS.IGS_EN_ELGBL_PROGRAM dependencies on IGS_PE_PERSON_TYPES

Line 40: g_system_person_type igs_pe_person_types.system_type%TYPE;

36: g_person_type igs_pe_usr_arg.person_type%TYPE;
37: g_enrollment_category igs_en_cpd_ext.enrolment_cat%TYPE;
38: g_comm_type igs_en_cpd_ext.s_student_comm_type%TYPE;
39: g_method_type igs_en_cpd_ext.enr_method_type%TYPE;
40: g_system_person_type igs_pe_person_types.system_type%TYPE;
41:
42: FUNCTION eval_program_steps( p_person_id NUMBER,
43: p_person_type VARCHAR2,
44: p_load_calendar_type VARCHAR2,

Line 88: FROM igs_pe_person_types

84: -- Cursor for getting the actual system person type for the person type that is passed
85: CURSOR cur_person_types
86: IS
87: SELECT system_type
88: FROM igs_pe_person_types
89: WHERE person_type_code = p_person_type;
90:
91: -- cursor rowtype variable
92: l_cur_person_types cur_person_types%ROWTYPE;