APPS.IEX_CASE_UTL_PUB dependencies on OKC_K_HEADERS_B

Line 1344: l_orig_system_source OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%type;

1340: l_resource_id NUMBER := nvl(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'),0);
1341:
1342: --Begin Bug#6962575 barathsr 29-Jul-2008
1343: --While creating cases in bulk skip finding the resource and assign default resource
1344: l_orig_system_source OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%type;
1345:
1346: cursor c_orig_system_source(p_contract_id number) is
1347: select ORIG_SYSTEM_SOURCE_CODE
1348: from OKC_K_HEADERS_B

Line 1348: from OKC_K_HEADERS_B

1344: l_orig_system_source OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%type;
1345:
1346: cursor c_orig_system_source(p_contract_id number) is
1347: select ORIG_SYSTEM_SOURCE_CODE
1348: from OKC_K_HEADERS_B
1349: where id=p_contract_id;
1350: --End Bug#6962575 barathsr 29-Jul-2008
1351:
1352:

Line 1971: from okc_k_headers_b

1967:
1968:
1969: cursor c_contract (p_contract_id IN NUMBER) is
1970: Select contract_number
1971: from okc_k_headers_b
1972: where id =p_contract_id;
1973: l_del_id NUMBER;
1974:
1975: BEGIN

Line 2130: from iex_case_objects a, okc_k_headers_b b

2126: -- Store the old case Id , will be used for re-score
2127: BEGIN
2128: select a.cas_id ,b.contract_number
2129: into l_old_case_id,l_contract_number
2130: from iex_case_objects a, okc_k_headers_b b
2131: where a.object_id =p_object_id
2132: and b.id =a.object_id;
2133:
2134: -- IF PG_DEBUG < 10 THEN