DBA Data[Home] [Help]

APPS.CS_SR_TASK_AUTOASSIGN_PKG dependencies on OKC_K_ITEMS

Line 446: FROM okc_k_items

442:
443: -- List of Cursors used
444: CURSOR C_CONTRACT(l_contract_service_id number) IS
445: SELECT to_number(object1_id1), to_number(object1_id2)
446: FROM okc_k_items
447: WHERE cle_id = l_contract_service_id;
448:
449: /*--Bug 5255184 Modified the c_area_code query
450: CURSOR c_area_code IS

Line 713: FROM okc_k_items

709:
710: -- List of Cursors
711: CURSOR c_contract(l_contract_service_id NUMBER)IS
712: SELECT TO_NUMBER(object1_id1), TO_NUMBER(object1_id2)
713: FROM okc_k_items
714: WHERE cle_id = l_contract_service_id;
715:
716: CURSOR c_area_code(c_incident_id NUMBER) IS
717: SELECT hzp.phone_area_code