DBA Data[Home] [Help]

APPS.PV_PARTNER_GEO_MATCH_PVT dependencies on HZ_LOCATIONS

Line 110: from hz_party_sites PS, hz_locations L

106: order by loc_type;
107:
108: CURSOR c_get_address(cv_partner_party_id NUMBER) IS
109: select L.postal_code, L.city, L.state, L.country
110: from hz_party_sites PS, hz_locations L
111: where PS.location_id = L.location_id
112: and PS.party_id = cv_partner_party_id
113: and PS.identifying_address_flag = 'Y';
114:

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';

Line 705: from hz_party_sites PS, hz_locations L

701: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
702:
703: CURSOR c_get_address(cv_party_id NUMBER) IS
704: select L.country
705: from hz_party_sites PS, hz_locations L
706: where PS.location_id = L.location_id
707: and PS.party_id = cv_party_id
708: and PS.identifying_address_flag = 'Y';
709: