87: where item.customer_item_id = p_cle_rec.customer_item_id;
88:
89: CURSOR get_intent IS
90: SELECT BUY_OR_SELL FROM
91: OKC_K_HEADERS_B H, OKC_K_LINES_B L
92: WHERE L.DNZ_CHR_ID = H.ID
93: AND L.ID = p_cle_rec.k_line_id;
94:
95: l_intent VARCHAR2(30);
578: l_lse_id NUMBER;
579:
580: CURSOR get_org IS
581: SELECT INV_ORGANIZATION_ID FROM
582: OKC_K_HEADERS_B H,OKC_K_LINES_B L
583: WHERE H.ID = L.DNZ_CHR_ID
584: AND L.ID = p_cle_rec.k_line_id;
585:
586: CURSOR get_lse_id IS