APPS.PV_USER_RESP_PVT dependencies on HZ_LOCATIONS

Line 6952: , hz_locations loc

6948: CURSOR get_party_id_csr ( p_location_id IN NUMBER ) IS
6949: SELECT partner_party_id
6950: FROM pv_partner_profiles prof
6951: , hz_party_sites st
6952: , hz_locations loc
6953: WHERE prof.partner_party_id = st.party_id
6954: AND prof.status = 'A'
6955: AND st.location_id=loc.location_id
6956: AND st.identifying_address_flag = 'Y'