APPS.OKL_VP_CR_WF dependencies on OKL_K_HEADERS

Line 148: ,okl_k_headers khr

144: ,po_vendors vendors
145: ,okc_k_party_roles_b party_roles
146: ,okl_vp_change_requests change
147: ,fnd_lookups lookups
148: ,okl_k_headers khr
149: WHERE agreement.scs_code = subclass.code
150: AND party_roles.dnz_chr_id (+) = agreement.id
151: AND party_roles.rle_code (+) = 'OKL_VENDOR'
152: AND party_roles.object1_id1 = vendors.vendor_id(+)

Line 562: (SELECT id FROM okl_k_headers WHERE crs_id = cr.id)

558: ,resultout OUT NOCOPY VARCHAR2) IS
559: -- cursor to get the agreement number that was created for the change request
560: CURSOR c_get_creq_chr_csr(cp_change_request_id okl_vp_change_requests.id%TYPE)IS
561: SELECT CASE WHEN (cr.change_type_code = 'AGREEMENT') THEN
562: (SELECT id FROM okl_k_headers WHERE crs_id = cr.id)
563: ELSE cr.chr_id END creq_chr_id
564: ,cr.change_type_code
565: FROM okl_vp_change_requests cr
566: WHERE cr.id = cp_change_request_id;