DBA Data[Home] [Help]

APPS.CS_ASSIGN_RESOURCE_PKG dependencies on OKC_K_ITEMS

Line 511: FROM okc_k_items

507: WHERE party_site_id = p_party_site_id;
508:
509: CURSOR C_CONTRACT(l_contract_service_id number) IS
510: SELECT to_number(object1_id1), to_number(object1_id2)
511: FROM okc_k_items
512: WHERE cle_id = l_contract_service_id;
513:
514: /* Waiting for JTA patch for their sql change so comment out for now
515: -- VIP Customer Code

Line 838: FROM okc_k_items

834: WHERE party_site_id = p_party_site_id;
835:
836: CURSOR c_contract(l_contract_service_id NUMBER)IS
837: SELECT TO_NUMBER(object1_id1), TO_NUMBER(object1_id2)
838: FROM okc_k_items
839: WHERE cle_id = l_contract_service_id;
840:
841: /* Waiting for JTA patch for their sql change so comment out for now
842: -- VIP Customer Code