APPS.IGS_SS_EN_WRAPPERS dependencies on IGS_PE_PERSON

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 3252: CURSOR cur_get_person_num(cp_person_id igs_pe_person.person_id%TYPE)

3248:
3249: --
3250: -- Cursor to find the Person Number associated with a Person Id
3251: --
3252: CURSOR cur_get_person_num(cp_person_id igs_pe_person.person_id%TYPE)
3253: IS
3254: SELECT party_number
3255: FROM hz_parties
3256: WHERE party_id = cp_person_id;

Line 3261: l_person_number igs_pe_person.person_number%TYPE;

3257:
3258:
3259:
3260: l_source_rowid VARCHAR2(20);
3261: l_person_number igs_pe_person.person_number%TYPE;
3262: l_enr_method igs_en_cat_prc_step.enr_method_type%TYPE;
3263: l_message VARCHAR2(100);
3264: l_return_status VARCHAR2(10);
3265:

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;