APPS.WSH_ITM_PARTY_SYNC dependencies on WSH_CARRIERS

Line 213: 'wsh_carriers_v wsh_car '||

209: ' FROM '||
210: 'hz_party_sites party_site,'||
211: 'hz_parties party,'||
212: 'hz_locations loc ,'||
213: 'wsh_carriers_v wsh_car '||
214: 'WHERE '||
215: ' party_site.party_id = party.party_id'||
216: ' AND wsh_car.ACTIVE = ''A'' '||
217: ' AND party.party_id = wsh_car.carrier_id'||

Line 507: WSH_CARRIERS WC,

503: CURSOR cur_carrier_party_name(c_freight_code varchar2) IS
504: SELECT
505: HP.PARTY_NAME
506: FROM
507: WSH_CARRIERS WC,
508: HZ_PARTIES HP
509: WHERE
510: HP.PARTY_ID = WC.CARRIER_ID AND
511: wc.freight_code = c_freight_code;