APPS.OKL_STRY_CALL_CO_PUB dependencies on PO_VENDORS

Line 170: ,po_vendors pv

166: --,pvs.email_address
167: FROM iex_cases_all_b ica
168: ,iex_case_objects ico
169: ,okc_k_party_roles_v opr
170: ,po_vendors pv
171: --,po_vendor_sites_all pvs
172: WHERE ica.case_number = cp_case_number
173: AND ica.cas_id = ico.cas_id
174: AND ico.object_id =opr.dnz_chr_id

Line 305: l_vendor_id PO_VENDORS.VENDOR_ID%TYPE;

301: where c.cas_id=d.case_id
302: and d.delinquency_id =p_delinquency_id;
303:
304: l_case_number IEX_CASES_ALL_B.CASE_NUMBER%TYPE;
305: l_vendor_id PO_VENDORS.VENDOR_ID%TYPE;
306: l_vendor_name PO_VENDORS.VENDOR_NAME%TYPE;
307:
308: Begin
309:

Line 306: l_vendor_name PO_VENDORS.VENDOR_NAME%TYPE;

302: and d.delinquency_id =p_delinquency_id;
303:
304: l_case_number IEX_CASES_ALL_B.CASE_NUMBER%TYPE;
305: l_vendor_id PO_VENDORS.VENDOR_ID%TYPE;
306: l_vendor_name PO_VENDORS.VENDOR_NAME%TYPE;
307:
308: Begin
309:
310: if funcmode <> 'RUN' then