APPS.CS_ASSIGN_RESOURCE_CON_PKG dependencies on OKC_K_ITEMS

Line 690: FROM okc_k_items

686: WHERE party_site_id = p_party_site_id;
687:
688: CURSOR C_CONTRACT(l_contract_service_id NUMBER)is
689: SELECT TO_NUMBER(object1_id1), TO_NUMBER(object1_id2)
690: FROM okc_k_items
691: WHERE cle_id = l_contract_service_id;
692:
693: CURSOR C_CLASS_CODE(l_party_id NUMBER,l_cust_category VARCHAR2) IS
694: SELECT class_code

Line 1009: FROM okc_k_items

1005: WHERE party_site_id = p_party_site_id;
1006:
1007: CURSOR c_contract(l_contract_service_id NUMBER) IS
1008: SELECT TO_NUMBER(object1_id1), TO_NUMBER(object1_id2)
1009: FROM okc_k_items
1010: WHERE cle_id = l_contract_service_id;
1011:
1012: CURSOR c_class_code(l_party_id NUMBER,l_cust_category VARCHAR2) is
1013: SELECT class_code