DBA Data[Home] [Help]

APPS.CS_ASSIGN_RESOURCE_PKG dependencies on OKC_K_ITEMS

Line 523: FROM okc_k_items

519: WHERE party_site_id = p_party_site_id;
520:
521: CURSOR C_CONTRACT(l_contract_service_id number) IS
522: SELECT to_number(object1_id1), to_number(object1_id2)
523: FROM okc_k_items
524: WHERE cle_id = l_contract_service_id;
525:
526: /* Waiting for JTA patch for their sql change so comment out for now
527: -- VIP Customer Code

Line 945: FROM okc_k_items

941: WHERE party_site_id = p_party_site_id;
942:
943: CURSOR c_contract(l_contract_service_id NUMBER)IS
944: SELECT TO_NUMBER(object1_id1), TO_NUMBER(object1_id2)
945: FROM okc_k_items
946: WHERE cle_id = l_contract_service_id;
947:
948: /* Waiting for JTA patch for their sql change so comment out for now
949: -- VIP Customer Code