APPS.OKL_STRY_CALL_CO_PUB dependencies on IEX_DELINQUENCIES_ALL

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 589: FROM iex_delinquencies_all ida

585: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
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

Line 705: FROM iex_delinquencies_all ida

701: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
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

Line 813: FROM iex_delinquencies_all ida

809: */
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

Line 841: iex_Delinquencies_all d

837: AND lease.contract_number = cp_contract_number;
838:
839: cursor c_get_case_id (p_delinquency_id IN NUMBER) is
840: select case_id from
841: iex_Delinquencies_all d
842: where delinquency_id =p_delinquency_id;
843:
844: BEGIN
845:

Line 945: FROM iex_delinquencies_all ida

941: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
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

Line 1042: FROM iex_delinquencies_all ida

1038: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
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

Line 1135: FROM iex_delinquencies_all ida

1131: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
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

Line 1230: FROM iex_delinquencies_all ida

1226: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
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

Line 1335: FROM iex_delinquencies_all ida

1331: */
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

Line 1363: iex_Delinquencies_all d

1359: AND lease.contract_number = cp_contract_number;
1360:
1361: cursor c_get_case_id (p_delinquency_id IN NUMBER) is
1362: select case_id from
1363: iex_Delinquencies_all d
1364: where delinquency_id =p_delinquency_id;
1365:
1366:
1367: