APPS.IGS_EN_ELGBL_UNIT dependencies on IGS_PE_PERSON

Line 99: FROM igs_pe_person_types

95: ------------------------------------------------------------------------------
96:
97: CURSOR cur_sys_pers_type(p_person_type_code VARCHAR2) IS
98: SELECT system_type
99: FROM igs_pe_person_types
100: WHERE person_type_code = p_person_type_code;
101:
102: -- Cursor to check whether unit is attempted for audit
103: CURSOR c_unit_aud_att IS

Line 155: l_system_type igs_pe_person_types.system_type%TYPE;

151:
152: cur_step_def_var cur_step_def; -- REF cursor variable
153: cur_step_def_var_rec step_rec;
154:
155: l_system_type igs_pe_person_types.system_type%TYPE;
156: l_message VARCHAR2(30);
157: l_usec_status igs_ps_unit_ofr_opt.unit_section_status%TYPE;
158: l_waitlist_ind VARCHAR2(1);
159: l_step_def_query VARCHAR2(2000);

Line 1026: FROM igs_pe_person_types

1022: -------------------------------------------------------------------------------------
1023: --
1024: CURSOR cur_pers_sys_type(p_person_type_code IN VARCHAR2) IS
1025: SELECT system_type
1026: FROM igs_pe_person_types
1027: WHERE person_type_code = p_person_type_code;
1028: --
1029: CURSOR cur_ss_enrol_ind(p_uoo_id NUMBER) IS
1030: SELECT ss_enrol_ind,unit_class,unit_cd

Line 1035: l_system_type igs_pe_person_types.system_type%TYPE ;

1031: FROM igs_ps_unit_ofr_opt
1032: WHERE uoo_id = p_uoo_id;
1033: --
1034: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
1035: l_system_type igs_pe_person_types.system_type%TYPE ;
1036: l_ss_enrol_rec cur_ss_enrol_ind%ROWTYPE ;
1037:
1038: l_message VARCHAR2(30);
1039: l_message_icon VARCHAR2(1);

Line 3500: CURSOR c_igs_en_su_attempt (cp_person_id igs_pe_person.person_id%TYPE,

3496: l_rowid VARCHAR2(25);
3497: l_rsv_ext_id NUMBER;
3498: l_rsv_temp_id NUMBER;
3499:
3500: CURSOR c_igs_en_su_attempt (cp_person_id igs_pe_person.person_id%TYPE,
3501: cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
3502: cp_course_cd igs_en_su_attempt.course_cd%TYPE
3503: ) IS
3504: SELECT *

Line 4941: FROM igs_pe_person_types

4937: ) RETURN BOOLEAN AS
4938:
4939: CURSOR cur_pers_sys_type(cp_person_type_code IN VARCHAR2) IS
4940: SELECT system_type
4941: FROM igs_pe_person_types
4942: WHERE person_type_code = cp_person_type_code;
4943:
4944: CURSOR c_admin_ovr (cp_person_type_code IN VARCHAR2) IS
4945: SELECT 'X'

Line 4966: l_system_type igs_pe_person_types.system_type%TYPE ;

4962: where uv.unit_cd = uoo.unit_cd
4963: and uv.version_number = uoo.version_number
4964: and uoo.uoo_id = p_uoo_id;
4965:
4966: l_system_type igs_pe_person_types.system_type%TYPE ;
4967: v_prog_award_ind igs_ps_type.AWARD_COURSE_IND%TYPE;
4968: v_unit_award_ind igs_ps_unit_ver.AWARD_COURSE_ONLY_IND%TYPE;
4969: l_step_override_limit number;
4970: l_dummy VARCHAR2(1);