APPS.AS_OSI_LEAD_PUB dependencies on HZ_PARTIES

Line 48: ,hz_parties cust

44: cursor osi2_cur (lead_id_in in varchar2) is
45: select substr(addr.address1||' '||addr.city||','||addr.state,1,50) site_name,
46: substr(cust.party_name,1,50) cust_name, substr(oppy.description,1,50) oppy_name
47: from as_leads_all oppy
48: ,hz_parties cust
49: ,as_party_addresses_v addr
50: where oppy.lead_id = lead_id_in
51: and cust.party_id = oppy.customer_id
52: and addr.address_id = oppy.address_id;