92: --Added cursor to fetch the vendor id to pass to business events
93: CURSOR get_vendor_id(p_chr_id okc_k_headers_b.id%TYPE,
94: p_cle_id okc_k_lines_b.id%TYPE) IS
95: SELECT object1_id1 vendor_id
96: FROM okc_k_party_roles_b
97: WHERE dnz_chr_id = p_chr_id
98: AND cle_id = p_cle_id
99: AND rle_code = 'OKL_VENDOR';
100:
397: --Added cursor to fetch the vendor id to pass to business events
398: CURSOR get_vendor_id(p_chr_id okc_k_headers_b.id%TYPE,
399: p_cle_id okc_k_lines_b.id%TYPE) IS
400: SELECT object1_id1 vendor_id
401: FROM okc_k_party_roles_b
402: WHERE dnz_chr_id = p_chr_id
403: AND cle_id = p_cle_id
404: AND rle_code = 'OKL_VENDOR';
405: