APPS.AS_OSI_LEAD_PUB dependencies on AS_LEADS_ALL

Line 47: from as_leads_all oppy

43: order by ovm_code;
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