APPS.CS_SR_TASK_AUTOASSIGN_PKG dependencies on OKC_K_ITEMS

Line 438: FROM okc_k_items

434:
435: -- List of Cursors used
436: CURSOR C_CONTRACT(l_contract_service_id number) IS
437: SELECT to_number(object1_id1), to_number(object1_id2)
438: FROM okc_k_items
439: WHERE cle_id = l_contract_service_id;
440:
441: --Bug 5255184 Modified the c_area_code query
442: CURSOR c_area_code IS

Line 647: FROM okc_k_items

643:
644: -- List of Cursors
645: CURSOR c_contract(l_contract_service_id NUMBER)IS
646: SELECT TO_NUMBER(object1_id1), TO_NUMBER(object1_id2)
647: FROM okc_k_items
648: WHERE cle_id = l_contract_service_id;
649:
650: CURSOR c_area_code(c_incident_id NUMBER) IS
651: SELECT hzp.phone_area_code