APPS.OKL_STRY_CALL_CO_PUB dependencies on IEX_CASE_OBJECTS

Line 136: select object_id from iex_case_objects

132: l_status VARCHAR(1);
133: --x_days NUMBER := 0;
134: x_greatest NUMBER := 0;
135: cursor c_contracts(p_case_id IN NUMBER) is
136: select object_id from iex_case_objects
137: where cas_id =p_case_id ;
138: BEGIN
139: FOR c_rec in c_contracts(p_case_id)
140: LOOP

Line 168: ,iex_case_objects ico

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
172: WHERE ica.case_number = cp_case_number

Line 183: ,iex_case_objects ico

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
187: AND ico.object_id = okh.id;

Line 590: ,iex_case_objects ico

586:
587: CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS SELECT ico.object_id
588: , okh.contract_number
589: FROM iex_delinquencies_all ida
590: ,iex_case_objects ico
591: ,okc_k_headers_b okh
592: WHERE ida.delinquency_id = cp_delinquency_id
593: AND ida.case_id = ico.cas_id
594: AND ico.object_id = okh.id;

Line 706: ,iex_case_objects ico

702:
703: CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS SELECT ico.object_id
704: , okh.contract_number
705: FROM iex_delinquencies_all ida
706: ,iex_case_objects ico
707: ,okc_k_headers_b okh
708: WHERE ida.delinquency_id = cp_delinquency_id
709: AND ida.case_id = ico.cas_id
710: AND ico.object_id = okh.id;

Line 814: ,iex_case_objects ico

810:
811: CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS
812: SELECT ico.object_id, okh.contract_number
813: FROM iex_delinquencies_all ida
814: ,iex_case_objects ico
815: ,okc_k_headers_b okh
816: WHERE ida.delinquency_id = cp_delinquency_id
817: AND ida.case_id = ico.cas_id
818: AND ico.object_id = okh.id;

Line 946: ,iex_case_objects ico

942:
943: CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS SELECT ico.object_id
944: , okh.contract_number
945: FROM iex_delinquencies_all ida
946: ,iex_case_objects ico
947: ,okc_k_headers_b okh
948: WHERE ida.delinquency_id = cp_delinquency_id
949: AND ida.case_id = ico.cas_id
950: AND ico.object_id = okh.id;

Line 1043: ,iex_case_objects ico

1039:
1040: CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS SELECT ico.object_id
1041: , okh.contract_number
1042: FROM iex_delinquencies_all ida
1043: ,iex_case_objects ico
1044: ,okc_k_headers_b okh
1045: WHERE ida.delinquency_id = cp_delinquency_id
1046: AND ida.case_id = ico.cas_id
1047: AND ico.object_id = okh.id;

Line 1136: ,iex_case_objects ico

1132:
1133: CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS SELECT ico.object_id
1134: , okh.contract_number
1135: FROM iex_delinquencies_all ida
1136: ,iex_case_objects ico
1137: ,okc_k_headers_b okh
1138: WHERE ida.delinquency_id = cp_delinquency_id
1139: AND ida.case_id = ico.cas_id
1140: AND ico.object_id = okh.id;

Line 1231: ,iex_case_objects ico

1227:
1228: CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS SELECT ico.object_id
1229: , okh.contract_number
1230: FROM iex_delinquencies_all ida
1231: ,iex_case_objects ico
1232: ,okc_k_headers_b okh
1233: WHERE ida.delinquency_id = cp_delinquency_id
1234: AND ida.case_id = ico.cas_id
1235: AND ico.object_id = okh.id;

Line 1336: ,iex_case_objects ico

1332:
1333: CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS
1334: SELECT ico.object_id, okh.contract_number
1335: FROM iex_delinquencies_all ida
1336: ,iex_case_objects ico
1337: ,okc_k_headers_b okh
1338: WHERE ida.delinquency_id = cp_delinquency_id
1339: AND ida.case_id = ico.cas_id
1340: AND ico.object_id = okh.id;