DBA Data[Home] [Help]

APPS.IGS_PE_PER_TYPE_MAP_PKG dependencies on PER_ALL_PEOPLE_F

Line 254: per_all_people_f ppf

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
258: (ti.end_date IS NULL OR (SYSDATE BETWEEN ti.start_date AND ti.end_date))