452: CURSOR c_location_id_csr (p_kle_id NUMBER, p_khr_id NUMBER )
453: IS
454: SELECT fdh.location_id
455: FROM okc_k_lines_b cleb_loc
456: ,fa_distribution_history fdh
457: ,okc_k_items cim
458: WHERE cleb_loc.cle_id = p_kle_id
459: AND cleb_loc.dnz_chr_id = p_khr_id
460: AND cleb_loc.lse_id = 42