APPS.OKL_SO_CREDIT_APP_WF dependencies on OKL_CREDIT_REQUESTS

Line 643: FROM okl_credit_requests

639: ,credit_khr_id
640: ,currency_code
641: ,org_id
642: ,created_by
643: FROM okl_credit_requests
644: WHERE credit_req_id = b_credit_request_id;
645:
646: -- cursor to get inventory org id of the sales quote
647: CURSOR c_get_inv_org_id (p_qte_id IN NUMBER) IS

Line 890: FROM OKL_CREDIT_REQUESTS

886: aname => 'ID');
887:
888: SELECT OBJECT_VERSION_NUMBER
889: INTO l_crqv_rec_type.OBJECT_VERSION_NUMBER
890: FROM OKL_CREDIT_REQUESTS
891: WHERE ID = l_okl_credit_req ;
892:
893: l_crqv_rec_type.ID := l_okl_credit_req ;
894: l_crqv_rec_type.STATUS := 'APPROVED';