APPS.IGS_PE_PER_TYPE_MAP_PKG dependencies on IGS_PE_PERSON_TYPES

Line 93: ELSIF NOT igs_pe_person_types_pkg.get_pk_for_validation (

89:
90: IF (((old_references.person_type_code = new_references.person_type_code)) OR
91: ((new_references.person_type_code IS NULL))) THEN
92: NULL;
93: ELSIF NOT igs_pe_person_types_pkg.get_pk_for_validation (
94: new_references.person_type_code
95: ) THEN
96: FND_MESSAGE.SET_NAME ('FND','FORM_RECORD_DELETED');
97: IGS_GE_MSG_STACK.ADD;

Line 250: CURSOR person_type_cur(cp_system_type igs_pe_person_types.system_type%TYPE) IS

246: || Who When What
247: || (reverse chronological order - newest change first)
248: */
249:
250: CURSOR person_type_cur(cp_system_type igs_pe_person_types.system_type%TYPE) IS
251: SELECT ti.rowid,ti.*
252: FROM igs_pe_typ_instances_all ti,
253: igs_pe_person_types pt,
254: per_all_people_f ppf

Line 253: igs_pe_person_types pt,

249:
250: CURSOR person_type_cur(cp_system_type igs_pe_person_types.system_type%TYPE) IS
251: SELECT ti.rowid,ti.*
252: FROM igs_pe_typ_instances_all ti,
253: igs_pe_person_types pt,
254: per_all_people_f ppf
255: WHERE ppf.party_id = ti.person_id AND
256: ti.person_type_code = pt.person_type_code AND
257: pt.system_type = cp_system_type AND

Line 272: igs_pe_person_types pt

268:
269: CURSOR ss_cur (cp_person_id HZ_PARTIES.PARTY_ID%TYPE) IS
270: SELECT ti.rowid,ti.*
271: FROM igs_pe_typ_instances_all ti,
272: igs_pe_person_types pt
273: WHERE ti.person_type_code = pt.person_type_code AND
274: pt.system_type = 'SS_ENROLL_STAFF' AND
275: ti.person_id = cp_person_id;
276: