APPS.IGS_SS_EN_WRAPPERS dependencies on IGS_PE_PERSON_TYPES

Line 247: FROM igs_pe_person_types

243: -- type only
244: -------------------------------------------------------------------------------------
245: CURSOR cur_get_person_type_by_rank( p_person_id NUMBER) IS
246: SELECT person_type_code
247: FROM igs_pe_person_types
248: WHERE rank = ( SELECT MIN(rank)
249: FROM igs_pe_person_types
250: WHERE person_type_code IN ( SELECT person_type_code
251: FROM igs_pe_typ_instances_all

Line 249: FROM igs_pe_person_types

245: CURSOR cur_get_person_type_by_rank( p_person_id NUMBER) IS
246: SELECT person_type_code
247: FROM igs_pe_person_types
248: WHERE rank = ( SELECT MIN(rank)
249: FROM igs_pe_person_types
250: WHERE person_type_code IN ( SELECT person_type_code
251: FROM igs_pe_typ_instances_all
252: WHERE person_id = p_person_id
253: )

Line 4098: FROM igs_pe_person_types

4094:
4095:
4096: CURSOR cur_per_typ IS
4097: SELECT person_type_code
4098: FROM igs_pe_person_types
4099: WHERE system_type = 'OTHER';
4100:
4101:
4102: CURSOR c_approv_perm IS

Line 4147: lv_person_type igs_pe_person_types.person_type_code%TYPE;

4143: AND uoo_id = cp_uoo_id;
4144:
4145: l_enr_method_type igs_en_cpd_ext.enr_method_type%TYPE;
4146: l_cur_per_typ cur_per_typ%ROWTYPE;
4147: lv_person_type igs_pe_person_types.person_type_code%TYPE;
4148: l_alternate_code igs_ca_inst.alternate_code%TYPE;
4149: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE;
4150: l_message fnd_new_messages.message_name%TYPE;
4151: l_acad_cal_type igs_ca_inst_rel.sub_cal_type%TYPE;