DBA Data[Home] [Help]

APPS.OKL_SUPP_INVOICE_DTLS_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 96: FROM okc_k_party_roles_b

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:

Line 401: FROM okc_k_party_roles_b

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: