APPS.CS_ASSIGN_RESOURCE_CON_PKG dependencies on OKC_K_ITEMS

Line 701: FROM okc_k_items

697: WHERE party_site_id = p_party_site_id;
698:
699: CURSOR C_CONTRACT(l_contract_service_id NUMBER)is
700: SELECT TO_NUMBER(object1_id1), TO_NUMBER(object1_id2)
701: FROM okc_k_items
702: WHERE cle_id = l_contract_service_id;
703:
704: CURSOR C_CLASS_CODE(l_party_id NUMBER,l_cust_category VARCHAR2) IS
705: SELECT class_code

Line 1065: FROM okc_k_items

1061: WHERE party_site_id = p_party_site_id;
1062:
1063: CURSOR c_contract(l_contract_service_id NUMBER) IS
1064: SELECT TO_NUMBER(object1_id1), TO_NUMBER(object1_id2)
1065: FROM okc_k_items
1066: WHERE cle_id = l_contract_service_id;
1067:
1068: CURSOR c_class_code(l_party_id NUMBER,l_cust_category VARCHAR2) is
1069: SELECT class_code