APPS.IGS_AD_IMP_008 dependencies on HZ_PERSON_PROFILES

Line 4478: FROM hz_person_profiles pp,

4474: WHERE mi.interface_run_id = l_interface_run_id
4475: AND mi.match_ind IS NULL
4476: AND mi.status = '2'
4477: AND EXISTS ( SELECT 1
4478: FROM hz_person_profiles pp,
4479: igs_pe_stat_details sd,
4480: igs_ad_interface_all ii
4481: WHERE ii.interface_run_id = l_interface_run_id AND
4482: ii.interface_id = mi.interface_id AND

Line 4614: hz_person_profiles pp,

4610: pp.content_source_type,
4611: pp.content_source_number,
4612: p.object_version_number object_version_number
4613: FROM
4614: hz_person_profiles pp,
4615: igs_pe_stat_details sd,
4616: hz_parties p
4617: WHERE
4618: sd.person_id(+) = p.party_id AND