DBA Data[Home] [Help]

APPS.IGS_PE_PER_TYPE_MAP_PKG dependencies on IGS_PE_TYP_INSTANCES_ALL

Line 252: FROM igs_pe_typ_instances_all ti,

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
255: WHERE ppf.party_id = ti.person_id AND
256: ti.person_type_code = pt.person_type_code AND

Line 271: FROM igs_pe_typ_instances_all ti,

267:
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;