APPS.PV_PARTNER_GEO_MATCH_PVT dependencies on PV_PARTNER_PROFILES

Line 611: from hz_party_sites PS, hz_locations L, pv_partner_profiles PP

607: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
608:
609: CURSOR c_get_address(cv_partner_id NUMBER) IS
610: select L.country
611: from hz_party_sites PS, hz_locations L, pv_partner_profiles PP
612: where PS.location_id = L.location_id
613: and PP.partner_party_id = PS.party_id
614: and PP.partner_id = cv_partner_id
615: and PS.identifying_address_flag = 'Y';