APPS.IGS_PE_GEN_004 dependencies on IGS_PE_PERSON_TYPES

Line 248: igs_pe_person_types typ

244: cp_system_type VARCHAR2)
245: IS
246: SELECT 1
247: FROM igs_pe_typ_instances_all inst,
248: igs_pe_person_types typ
249: WHERE inst.person_type_code = typ.person_type_code AND
250: inst.person_id = cp_person_id AND
251: typ.system_type = cp_system_type AND
252: SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE);