DBA Data[Home] [Help]

APPS.IGS_PE_PERSON_SS_PKG dependencies on IGS_PE_HZ_PTY_SITES

Line 2349: igs_pe_hz_pty_sites ihps

2345: hps.status
2346: FROM
2347: hz_locations hl,
2348: hz_party_sites hps,
2349: igs_pe_hz_pty_sites ihps
2350: WHERE hl.location_id = hps.location_id
2351: AND hps.party_id = cp_subject_id
2352: AND hps.identifying_address_flag = 'Y'
2353: AND hps.party_site_id = ihps.party_site_id(+);