APPS.IGS_FI_PRC_APINT dependencies on HZ_PARTY_SITE_USES

Line 247: hz_party_site_uses psu,

243: -- Cursor for selecting an Active Pay to Usage address for a party
244: CURSOR c_hz_site(cp_n_party_id hz_parties.party_id%TYPE) IS
245: SELECT ps.location_id
246: FROM hz_party_sites ps,
247: hz_party_site_uses psu,
248: igs_pe_hz_pty_sites ips
249: WHERE ps.party_site_id = ips.party_site_id(+)
250: AND ps.party_id = cp_n_party_id
251: AND (ps.status = g_v_ind_a AND