APPS.OKL_STRY_CALL_CO_PUB dependencies on IEX_CASES_ALL_B

Line 167: FROM iex_cases_all_b ica

163: --get vendor info
164: CURSOR l_vendor_csr(cp_case_number IN VARCHAR2) IS SELECT pv.vendor_id
165: ,pv.vendor_name
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

Line 182: FROM iex_cases_all_b ica

178:
179: --get contracts on case
180: CURSOR l_khr_csr(cp_case_number IN VARCHAR2) IS SELECT ico.object_id
181: , okh.contract_number
182: FROM iex_cases_all_b ica
183: ,iex_case_objects ico
184: ,okc_k_headers_b okh
185: WHERE ica.case_number = cp_case_number
186: AND ica.cas_id = ico.cas_id

Line 300: select c.case_number from iex_cases_all_b c,iex_Delinquencies_all d

296: -- this contract id will be used as the
297: --bind variable for fullfillment template.
298:
299: cursor c_get_case_number (p_delinquency_id IN NUMBER) is
300: select c.case_number from iex_cases_all_b c,iex_Delinquencies_all d
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;

Line 304: l_case_number IEX_CASES_ALL_B.CASE_NUMBER%TYPE;

300: select c.case_number from iex_cases_all_b c,iex_Delinquencies_all d
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