[Home] [Help]
702: AND VS.vendor_id = PV.vendor_id;
703:
704: CURSOR get_party_role_csr (p_party_id NUMBER) IS
705: SELECT ROL.rle_code party_role
706: FROM OKC_K_PARTY_ROLES_V ROL
707: WHERE ROL.id = p_party_id;
708:
709: l_return_status VARCHAR2(3) := G_RET_STS_SUCCESS;
710: l_msg_tbl msg_tbl_type;